Versions Compared

Key

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


The information on this page refers to License Statistics v5.15 or newer, which upgraded MySQL to v5.7. If you are using an earlier version of License Statistics, please refer to the documentation for releases prior to v5.15.


Info
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.

...

Info

Important: All automated scripts (mysql_xxx.bat or mysql_xxx.sh) described in this document are configured to operate on an embedded database running on default configuration settings, as listed below. In all other cases (different configuration or external database), you must either do manual operations on the database or adjust the scripts to your custom needs.

Default settings for embedded database:

HostPortUserPasswordDatabase Name
localhost3306root
xformation_licstat


Determining how to do the backup

You should use the automated backup and restore scripts provided with License Statistics if possible. However, if your needs and installation do not allow you to use the automated scripts, you can perform the backup and restore procedures manually.

Using License Statistics backup and restore scripts

License Statistics includes the following scripts for automating backups when the database created by License Statistics (EMBEDDED64) is used with default settings. Review these scripts so you are familiar with what they do, and decide if they will work for your backup and restoration needs.

...

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).

Backing up and restoring the database manually

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 with any custom settings, such as a custom database name, port, password set, or different user.

If you must do a manual backup, review the scripts to base the backup on what is done in the scripts.

Preparing for the backup

Before you begin your database backup:

  1. Go to the License Statistics installation directory and select the MySQL directory for your License Statistics database. This directory is named mysql.
  2. Ensure you have enough space for the database dump.

Backing up the database

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.

...

  1. Copy the backup file to a safe location.
  2. Copy your License Statistics configuration file (xflicstat.cfg), license file (license.lic), and 3rd party utilities (for example, lmutil.exe) to a safe location.

Anchor
Restoring database
Restoring database
Restoring the database

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.

...