...
| Script for Windows | Script for Linux | Description |
|---|---|---|
| mysql_start.bat | mysql_start.sh | Starts the MySQL database. |
| mysql_stop.bat | mysql_stop.sh | Stops the MySQL database. |
| mysql_backup.bat | mysql_backup.sh | Backs up the License Statistics database. |
| mysql_restore.bat | mysql_restore.sh | Restores the License Statistics database. |
| mysql_start_backup_stop.bat | mysql_start_backup_stop.sh | Starts, backs up, and stops the MySQL database. |
| mysql_start_restore_stop.bat | mysql_start_restore_stop.sh | Starts, restores, and stops the the MySQL database. |
| mysql_clean.bat | mysql_clean.sh | Drops (removes) the License Statistics database. |
| Info |
|---|
| Note: You may not be able to run the scripts as a normal user on Windows due to Windows limitations, so be sure to run the scripts as an administrator (see http://technet.microsoft.com/en-en/library/cc947813(v=ws.10).aspx for instructions on starting a command prompt as an administrator). |
...
- 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.
...