Managing NerveCenter - Managing the Database - Restoring the Database - Restoring the Database from the Command Line -
Previous: Restoring the Database Using the SerializeDB Application     Next: Upgrading an Access Database

Restoring the Database from the Command Line

When you run SerializeDB from the command line, SerializeDB imports the data into your database from a serialized ASCII file. You can issue SerializeDB commands from a script. For example, on UNIX, you can write a script called restorencdb that shuts down the server, imports the data from backup.asc, and restarts the server.

---

Caution    Before you restore the database, you must shut down the NerveCenter Server. If you don't shut down the NerveCenter Server, you could lose data.

If you are restoring a UNIX flat file database, all of the files that make up the database must be in the db directory. See Database Formats for more information.

---

 
  To restore the database using the command line:

1. Enter one of the following:
   • At a DOS prompt:
        serializedb -F backupfile.asc -O FileToDB -R|C "DSN=datasourcename;UID=userID;PWD=password"

     Replace backupfile.asc with the name of the file you want SerializeDB to import. If your current working directory is not the directory in which backupfile.asc is located, specify the path with the name of the file.

     Use -R to have SerializeDB get the data source name, user ID, and password from the registry. You can use -R with a Microsoft SQL Server database or a Microsoft Access database. Use -C "DSN=datasourcename;UID=userID;
     PWD=password" instead of -R only if you are restoring a Microsoft SQL Server database. Replace datasourcename with the existing data source name, userID with the appropriate SQL Server user ID, and password with the corresponding password.

   • In a UNIX shell:

     ---

     Caution    On UNIX, SerializeDB requires an Xdisplay even when running in command line mode. Therefore, do not run SerializeDB remotely or on a headless server via a TTY.

     ---

     
        serializedb -F backupfile.asc -O FileToDB -R -D nervecenter.ncdb

     Replace backupfile.asc with the name of the file you want SerializeDB to import. If your current working directory is not the directory in which backupfile.asc is located, specify the path with the name of the file.

     ---

     Note    The *.ncdb file must not have more than one period (.) in the name -- nervecenter.old.ncdb, for example.

     ---

2. Check to make sure the data was imported.

   ---

   Tip    Use the timestamp and the size of the file as an indicator of success. For example, if the timestamp is old or the file size is 0K, you need to investigate further.

   ---

If the SerializeDB does not import the data successfully, check the Event Log on Windows NT or the system log on UNIX for error messages.