Dump the New STA Database (Task 6) - Optional

Dumping the new database is optional but recommended. If the database upgrade fails, you can restore the empty database to recover STA as if it were newly installed with no data.

1. On the STA server, open a terminal session. Log in as the Oracle user.
2. If you have not done so already, stop all STA services:

   $ STA stop all
   

3. Start the MySQL service:

   $ STA start mysql
   

4. Create the database backup file (do not use the -v (verbose) option). Enter the database root user password when prompted.

   $ mysqldump -uroot -p --opt --add-drop-database --comments --complete-insert --dump-date --events --flush-logs --routines --single-transaction --triggers --databases stadb > /dumpfile_path/dumpfile_name.sql
   

   In following example, the STA database is dumped to the /home/oracle folder on the STA server with filename STA_FRESH_INSTALL_BACKUP.sql.

   $ mysqldump -uroot -p --opt --add-drop-database --comments --complete-insert --dump-date --events --flush-logs --routines --single-transaction --triggers --databases stadb >  /home/oracle/STA_FRESH_INSTALL_BACKUP.sql
   

   If you see, "Can't connect to local MySQL server," the MySQL server is not running. Make sure you have started MySQL.