http://in.compucrete.com/index.php?action=history&feed=atom&title=Database_TipsDatabase Tips - Revision history2026-05-15T15:13:28ZRevision history for this page on the wikiMediaWiki 1.40.0http://in.compucrete.com/index.php?title=Database_Tips&diff=112&oldid=prevWikiAdmin: 1 revision imported2023-07-14T12:58:48Z<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>WikiAdminhttp://in.compucrete.com/index.php?title=Database_Tips&diff=111&oldid=prevPmorey: /* Company Database Update Auto-Backup */2017-07-14T14:00:14Z<p><span dir="auto"><span class="autocomment">Company Database Update Auto-Backup</span></span></p>
<p><b>New page</b></p><div>==Restoring the master (empty) database==<br />
<br />
Change to the Interbase BIN directory:<br />
<br />
<PRE>CD \Program Files\Borland\Interbase\Bin</PRE><br />
<br />
For a single-user system, use the following command:<br />
<br />
<PRE>gbak -r -user CCWIN -password <password> "c:\program files\givenhansco\cc\template\ccwmco.ibt" "c:\program files\givenhansco\cc\cust\data\ccw001.ib"</PRE><br />
<br />
For a multi-user system, use the following command, substituting the appropriate IP address and database path:<br />
<br />
<PRE>gbak -r -user CCWIN -password <password> "c:\program files\givenhansco\cc\template\ccwmco.ibt" 127.0.0.1:c:\ccgh\data\ccw001.ib</PRE><br />
<br />
NOTE: Replace <password> with standard database password.<br />
<br />
<br />
==Company Database Upgrade Auto-Backup==<br />
<br />
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:<br />
<br />
CCW<i>nnn</i>_1.bak (where <i>nnn</i> is the company id)<br />
<br />
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#ccwconfig|Keystone Configuration Options]].</div>Pmorey