...
License Statistics includes the following scripts for automating backups when the database created by License Statistics EMBEDDED64 is used with default settings (or EMBEDDED32 for versions older than 4.19.1). Review these scripts so you are familiar with what they do, and decide if they will work for your backup and restoration needs.
| Script | Description |
|---|---|
| mysql_start | Starts the MySQL database. |
| mysql_stop | Stops the MySQL database. |
| mysql_backup | Backs up the License Statistics database. |
| mysql_restore | Restores the License Statistics database. |
| mysql_start_backup_stop | Starts the MySQL database, backs up the database, and stops the database. |
| mysql_start_restore_stop | Starts the MySQL database, restores the database, and stops the database. |
...
- 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 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.bat, and finally mysql_stop.bat.
- Put the saved database dump in the mysql directory under the License Statistics installation directory.
- Restore the database using the mysql_restore script.
- Run mysql_stop in order to shut down the MySQL database.
- As an alternative, you can use the mysql_start_restore_stop script to start, restore and stop the database all in one step.
...