...
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_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. Backing up the database when License Statistics is running will cause the database dump to be inconsistent with the current state of monitored data.
- Start the MySQL database using the mysql_start script.
- Create a database backup using the mysql_backup script.
- Open a command prompt with full administrator permissions (see http://technet.microsoft.com/en-en/library/cc947813(v=ws.10).aspx for instructions on starting a command prompt as an administrator).
- Navigate to the database folder named mysql under the License Statistics directory.
- Execute mysql_start.bat to launch MySQL client.
- After MySQL starts, execute mysql_backup.bat. The script creates a .dump fileAs an alternative, you can use the mysql_start_backup_stop script to start the database, backup the database, and stop the database all in one step.
Backing up the database may take a long time, depending on the volume of data in your database.
The script creates the xformation_licstat.dump file.
...
| Anchor | ||||
|---|---|---|---|---|
|
The following instructions assume that you are using the License Statistics scripts to restore the database. If you are restoring the database manually, use the scripts to guide you in what is needed for manual restoration.
...
- 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.
- As an alternative, you can use the mysql_start_restore_stop script to start, restore and stop the database all in one step.
...