...
Script | Description |
---|---|
mysql_backup | Backs up the License Statistics database. |
mysql_restore | Restores the License Statistics database. |
mysql_start_backup_stop | Starts the MySQL databasesdatabase, backs up the database, and stops the database. |
mysql_start_restore_stop | Starts the MySQL databasesdatabase, 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.
- As an alternative, you can use the mysql_start_backup_stop script to start the database, backup the database, and stop the database all at in one timestep.
Backing up the database may take a long time, depending on the volume of data in your database.
The script creates two files:
...
- Stop License Statistics. Restoring the database when License Statistics is running will cause the state of the database to be inconsistent with monitored data.
- 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 at in one timestep.
Restoring the database may take a long time, depending on the volume of data in your database.
...