Database Tips

Restoring the master (empty) database

Change to the Interbase BIN directory:

CD \Program Files\Borland\Interbase\Bin

For a single-user system, use the following command:

gbak -r -user CCWIN -password <password> "c:\program files\givenhansco\cc\template\ccwmco.ibt" "c:\program files\givenhansco\cc\cust\data\ccw001.ib"

For a multi-user system, use the following command, substituting the appropriate IP address and database path:

gbak -r -user CCWIN -password <password> "c:\program files\givenhansco\cc\template\ccwmco.ibt" 127.0.0.1:c:\ccgh\data\ccw001.ib

NOTE: Replace <password> with standard database password.

Company Database Upgrade Auto-Backup

When a company database needs to be upgraded (such as after installing a Keystone update) an automatic backup is made of the company database. The filename for this backup is:

CCWnnn_1.bak (where nnn is the company id)

The backup will be placed in the Keystone Backup folder on the PC where the user logged in to initiate the database upgrade. There is a configuration INI file that can be used to specify the location of the Keystone Backup folder. See: Keystone Configuration Options.