Reload the STA database from the last full database dump.

1. On the STA server, open a terminal session. Log in as the Oracle user.
2. Ensure there is no residual STA database left on the server. The STA database has the name stadb. For example:

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

   where:

   • -u root indicates to execute the command as the MySQL root user

   • -p indicates to prompt for the user password.

   • -e indicates to execute the following MySQL statement and then quit the mysql command. The statement must be enclosed in quotes.

     • 'drop database stadb'—Removes the database named stadb, which is the STA database.

3. Load the latest full database backup. For example:

   $ mysql –u root –p –e 'source 20130723_133755.stafullbackup.sql;'
   Password:
   

   where:

   • -u root specifies the MySQL root username.

   • -p indicates to prompt for the user password.

   • -e indicates to execute the following MySQL statement and then quit the mysql command. The statement must be enclosed in quotes.

     • 'source 20130723_133755.stafullbackup.sql;'— Executes the specified database dump file; the dump file creates the schema and installs all the data.

4. Continue to either of the following:

   • Perform a Full Restore From All Incremental Backups.

   • Perform a Partial Restore From a Range of Incremental Backups. Use this if you suspect a database operation may have corrupted the database and you only want to restore operations up to, but not including, that one.