Restore STA

Reinstall STA and restore the database to repair a current installation. You cannot use the STA installer to reinstall or overwrite a current installation, you must first deinstall the current version of STA and then reinstall STA.

1. Make sure you have removed STA from the server.

   See Deinstall STA.

2. Reinstall STA as if it were a new installation.

   See Install STA.

3. On the STA server, open a terminal session. Log in as the Oracle user.
4. Stop all STA services:

   $ STA stop all
   

5. Transfer the database dump.

   $ scp -p <backup_host>:/<path_to_dump_file>/<dump_name> /<local_path>
   

   For example, the dump file Jan26_dump.sql.gz is transferred from /dbdumpfiles on host backup1 to the /home/oracle folder on the STA 2.3.1 server.

   $ scp -p backup1:/dbdumpfiles/Jan26_dump.sql.gz /home/oracle
   

6. Perform a checksum of the transferred file. Verify the checksum value matches the one you received when creating the database dump.

   $ cd /home/oracle/
   $ cksum <dump_name>
   

7. Decompress the backup file.

   $ unzip <dump_name>
   

8. Start the MySQL server:

   $ STA start mysql
   

9. Ensure there is no residual STA database (stadb) on the server. For example:

   $ mysql –u root –p –e 'drop database stadb;'
   

10. Load the old STA database (do not use the -v (verbose) option). Enter the database root user password when prompted. There is no command output as the process runs.

    $ mysql -u root -p -e 'source /<path_to_dump_file>/<dump_name>;'
    

    If the command is successful, you are returned to the command prompt once the process completes.

11. Start all STA services: $ STA start all
12. Configure STA.

    See Configure Library Connection Settings in STA and Configure STA Services and User Information.