Dump the database before deinstalling STA. You can use the database dump to restore the data after reinstallation.
On the STA server, open a terminal session. Log in as the Oracle user.
Stop all STA services:
$ STA stop all
Start the MySQL service:
$ STA start mysql
Create a backup file.
$ /usr/bin/mysqldump -u root -p --opt --routines --triggers --events --flush-logs --single-transaction --complete-insert --comments --dump-date --add-drop-database --databases stadb -v > /<sta_db_backup>/<backup_filename>.sql Enter password: mysql_root_password
Output will be similar to the following:
... -- Retrieving view structure for table v_mdv_request_states... -- Retrieving view structure for table version_info... ... -- Disconnecting from localhost...
Note:
If you see "Can't connect to local MySQL server," the MySQL server is not running. Verify you have started MySQL.