The information on this page refers to License Statistics v5.15 or newer.
Note: We recommend that you make a backup of your database before performing any operations in order to avoid data loss or corruption.

Initial statements 

  1. As of December 31, 2018, MySQL 5.5 is no longer officially supported by the vendor.
  2. License Statistics versions older than v5.15 require MySQL 5.5.x.
  3. License Statistics v5.15 and newer require MySQL 5.7.x.
  4. Both EMBEDDED and EXTERNAL databases need to be upgraded in order for License Statistics v5.15 to run.  

Upgrading an EMBEDDED MySQL database

If you are using an embedded MySQL database, you can perform License Statistics upgrade procedure, in short:

  1. Stop the old version (older than v5.15) of License Statistics.
  2. Create a backup of the MySQL 5.5 database.
  3. Remove the old version of License Statistics.
  4. Install the new version of License Statistics (v5.15 or above) with an embedded database.
  5. Restore the MySQL 5.5 database backup to the new MySQL 5.7 database.
  6. Start License Statistics. 

Upgrading an EXTERNAL MySQL database

If you are using an external database (recommended), you need to perform License Statistics upgrade procedure. The fundamental difference with upgrading an external database is the requirement to update or create a new MySQL version 5.7.x database, which you can do using one of the following two methods.

Method 1: Backup and restore the database

This is the easier solution, but can be more time consuming when upgrading larger databases. The backup of an old MySQL 5.5 database can be successfully restored on MySQL 5.7.

  1. Stop the old version (older than v5.15) of License Statistics.
  2. Create a backup of the the MySQL 5.5 database.
  3. Create a new external MySQL 5.7 instance.
  4. Configure the new MySQL 5.7 database by copying the {License Statistics installation}/mysql/config.ini settings, and optionally adjust the settings for your needs.
  5. Restore the MySQL 5.5 database backup to the new MySQL 5.7 database.
  6. Remove the old version of License Statistics.
  7. Install the new version of License Statistics (v5.15 or above).
  8. Change the database credentials in the xflicstat.cfg file.  
  9. Start License Statistics.

Method 2: Follow the official MySQL upgrade procedure

This solution should be faster when upgrading a larger database, but it operates on an existing MySQL instance, so it's highly recommended to create a backup of your database or even the entire host, if applicable.

  1. Stop the old version (older than v5.15) of License Statistics.
  2. Create a backup of the MySQL 5.5 database or the entire host.
  3. Follow one of the official procedures that matches your environment, as described at https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
  4. Remove the old version of License Statistics.
  5. Install the new version of License Statistics (v5.15 or above).
  6. Configure the new MySQL 5.7 database by copying {License Statistics installation}/mysql/config.ini settings, and optionally adjust the settings for your needs.
  7. Start License Statistics.
  • No labels