Load the decompressed dump file into the database on the target server.

1. On the target server, open a terminal session. Log in as the Oracle user.
2. Stop all STA processes:

   $ STA stop all
   

3. Restart the MySQL server:

   $ STA start mysql
   

4. Load the dump file into the STA database. Enter the database root user password when prompted. For example:

   $ mysql -u root -p -e "SET SESSION SQL_LOG_BIN=0; SOURCE /tmp/160115_SavedSTADatabase.sql;"
   Password:
   $

   where:

   • -u root specifies the database root username.
   • -p indicates to prompt for the user password.
   • -e indicates to execute the following MySQL statements and then quit the mysql command. The statements must be enclosed in quotes.
     • SET SESSION SQL_LOG_BIN=0;—Temporarily disables binary logging during the load, speeding up the process.
     • SOURCE /tmp/160115_SavedSTADatabase.sql—Loads the dump file into the database.

   There is no command output as the process runs. If the command is successful, you are returned to the command prompt once the process completes.

   Note:

   The --verbose command option is not recommended, as it displays many messages in the terminal window and can significantly slow down the command process for large databases.