Database Restore - dbrestore
dbrestore is a command line program which can be used to restore some or all of the MBS database from a folder previously created by the dbbackup program. The program populates the database using the information contained in the backup files.
Important: Data should only be restored to the same version of the program as it was backed up with. The dbrestore 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
c:\Program Files (x86)\SwiftTec\Club Membership System
Once your have changed to that folder run the command:
where backupfolder is the name of the folder containing data generated by dbbackuip.
You can specify the following parameters on the command line:
|--tables tablelist||Restrict restoration to the tables listed in the table list. tablelist is a comma-separated list of table names.|
Copyright 2014 SwiftTec - All Rights Reserved