Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ScriptDescription
mysql_backupBacks up the License Statistics database.
mysql_restoreRestores the License Statistics database.
mysql_start_backup_stopStarts the MySQL databasesdatabase, backs up the database, and stops the database.
mysql_start_restore_stopStarts the MySQL databasesdatabase, restores the database, and stops the database.

...

  1. 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.
  2. Start the MySQL database using the mysql_start script.
  3. Create a database backup using the mysql_backup script.
  4. 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:

...

  1. Stop License Statistics. Restoring the database when License Statistics is running will cause the state of the database to be inconsistent with monitored data.
  2. Start the MySQL database using the mysql_start script.
  3. If the database already exists, drop it before attempting the restore by running mysql_clean.bat, and finally mysql_stop.bat.
  4. Put the saved database dump in the mysql directory under the License Statistics installation directory.
  5. Restore the database using the mysql_restore script. 
  6. 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.

...