Show TOC

Procedure documentationReloading a Database

Procedure

Whenever a table or database is unloaded, Sybase creates a reload.sql file, which contains a series of SQL commands designed to reload the database structure and data. The sequence of functions a troubleshooter tends to use is first, to unload the suspected table or database, erase that table or database, then reload the table or database.

To reload an entire database that has been previously unloaded:

  1. Ensure that the Sybase server is running.

  2. Using ‘SQL Central’, click on the ‘Utilities’ folder.

  3. Double-click the left mouse button on the ‘ISQL’ (Interactive SQL) utility.

  4. When the Interactive SQL Logon window appears, login as dba with sql as the password.

  5. In the Command window (lower portion) of the ISQL screen, type the SQL command to read the reload.sql file.

    The command consists of two parts:

    • Read: Tells SQL to search for a file and read (or run) that file.

    • Path and File Name: Specifies the location and name of the required ‘reload.sql’ file.

  6. Click Execute. ISQL retrieves the reload.sql file and starts reading through all of the SQL commands written within it. The file recreates the structure and data of all tables and functions from the database. As the file is read, the Command portion of the ISQL screen displays the commands being read from the file.