Reloading a table that has been unloaded is slightly different than reloading an entire database that has been unloaded. Regardless of what is unloaded from the database, the reload.sql
file is identical. It is created to reload the entire database even if only
one or two tables have been unloaded. Because of this fact, when reloading tables you must use only the portions of the reload.sql
file that relate to the specified tables.
Locate the reload.sql
file (located by default in the C:\Program Files\Triversity Databases directory) and open it using Microsoft Wordpad.
Click the Edit
menu, and then click Find
.
In the Find What
field, type the name of the table you have unloaded, and then click Find Next
. If you have unloaded more than one table, search for all entries of a given table before searching for another table (that is, search
for one table name at a time).
Highlight the full SQL command surrounding the required table name for every mention of the name that is found in the reload.sql
file.
Right-click any portion of the highlighted SQL command, and then click Copy
.
Open ISQL.
In the ISQL window, right-click the Command
section (at the end of any previously pasted commands) and then click Paste
.
Repeat steps 2 through 7 until all SQL commands referencing the unloaded table(s) are copied from the reload.sql
file into the Command
section of the ISQL window.
Click Execute
to reload the table(s).