Important: Be sure to make a backup before uninstalling License Statistics. All files will be deleted from the License Statistics installation directory during the uninstallation.
You can use automated backup and restore scripts provided with License Statistics or you may need to perform the backup and restore procedures manually, depending on your needs and your installation.
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. |
Note that 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).
When running License Statistics using an external database that is not maintained by License Statistics, you must do manual backups instead of using the supplied scripts. You must also do manual backups if you are running EMBEDDED64 (or EMBEDDED32 for version lower than v4.19.1) with any custom settings, such as custom database name, port, password set, or different user.
If you must do a manual backup, review the scripts to do the backup according to what is done in the scripts.
Before you begin your database backup:
The following instructions assume that you are using the License Statistics scripts to backup the database. If you are backing up the database manually, use the scripts to guide you in what is needed for manual backup, and be sure the backup includes all stored procedures and views.
To perform a backup of the License Statistics database:
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.
When the backup is complete:
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.
To restore the data:
Restoring the database may take a long time, depending on the volume of data in your database.
Note: When upgrading License Statistics to a new version, you do not have to restore the database dump. You can use a new database (not necessarily the one that was used before upgrading) as well.
After the database is restored: