Database Backup - dbbackup

dbbackup is a command line program which can be used to backup some or all of the MBS database to a folder. The program creates a number of files containing the data from all the tables and a control file called dbbackup.ini.

The dbbackup program only works with non file based databases such as MySQL and SQL Server.

How to run the program

The program is designed to be run from a command window. You can start a command windows using one of the following mechanisms:

From the windows start menu select Run (or press the Windows Key and the letter R) and enter cmd as the command to run
Select command prompt from All Programs/Accessories
From the windows start menu type cmd in the search box and run the program when found.

In the command box go to the folder where the program is installed. The exact location will depend on which software suite you have installed and your windows setup. For the Club Membership System you should find it in:

c:\Program Files\SwiftTec\Club Membership System
or
c:\Program Files (x86)\SwiftTec\Club Membership System

Once your have changed to that folder run the command:

dbbackup targetfolder

where targetfolder is the name of the folder in which you wish to create the backup.

Optional Parameters

You can specify the following parameters on the command line:

--help	Display help
--tables tablelist	Restrict backup to the tables listed in the table list. tablelist is a comma-separated list of table names.