...
| Info | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
Important: All automated scripts (mysql_xxx.bat or mysql_xxx.sh) described in this document section are configured to operate on an embedded database running on with default configuration settings, as listed below. In all other cases (different configuration or external database), you must either do manual operations on the database or adjust the scripts to your custom needs. Default settings for embedded database:
|
...
- Stop License Statistics. Backing up the database when License Statistics is running will cause the database dump to be inconsistent with the current state of monitored data.
- Open a command prompt with full administrator permissions.
- Navigate to the database folder named "mysql" under the License Statistics installation directory.
- Execute the "mysql_start" script to launch MySQL client.
- After MySQL starts, execute the "mysql_backup" script. This script creates a .dump file in the directory from which the script was executed.
- When the backup is complete, execute the "mysql_stop" script.
| Tip |
|---|
You can perform steps 4-6 at the same time rather than individually by using the "mysql_start_backup_stop" script. |
...
- Stop License Statistics. Restoring the database when License Statistics is running will cause the state of the database to be inconsistent with monitored data.
- Open a command prompt with full administrator permissions.
- Navigate to the database folder named "mysql" under the License Statistics installation directory.
- Put the saved database dump in the "mysql" directory.
- Start the MySQL database using the "mysql_start" script.
- If the database already exists, drop it before attempting the restore by running "mysql_clean".
- Restore the database using the "mysql_restore" script.
- Run the "mysql_stop" script to shut down the MySQL database.
| Tip |
|---|
You can perform steps 5, 7 and 8 at the same time rather than individually using the "mysql_start_restore_stop" script; however, this script will work only if the database doesn't already exist. |
...