Dump the Database

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.