The information on this page refers to License Statistics v6.18 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 October 31, 2023, MySQL 5.7 is no longer officially supported by the vendor.
  2. License Statistics versions older than v6.18 require MySQL 5.7.x.
  3. License Statistics v6.18 and newer require MySQL 8.0.x (8.0.31 and above).
  4. Both EMBEDDED and EXTERNAL databases need to be upgraded in order for License Statistics v6.18 to run.  

Upgrading an EMBEDDED MySQL database

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

  1. Stop the old version (older than v6.18) of License Statistics.
  2. Create a backup of the MySQL 5.7 database (just in case it's needed).
  3. Upgrade License Statistics to v6.18 or above.
  4. Start License Statistics. 

Upgrading an EXTERNAL MySQL database

If you are using an external database (recommended), you need to perform a License Statistics upgrade procedure. The fundamental difference with upgrading an external database is the requirement to update or create a new MySQL version 8.0.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.7 database can be successfully restored on MySQL 8.0.

  1. Stop the old version (older than v6.18) of License Statistics.
  2. Create a backup of the the MySQL 5.7 database.
  3. Create a new external MySQL 8.0 instance.
  4. Configure the new MySQL 8.0 database by copying the settings in License Statistics installation directory/mysql/my.ini, and adjusting the settings for your needs.
  5. Restore the MySQL 5.7 database backup to the new MySQL 8.0 database.
  6. Upgrade License Statistics to v6.18 or above.
  7. Change the database credentials using License Statistics Manager or by editing the xflicstat.cfg file directly.  
  8. 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 v6.18) of License Statistics.
  2. Create a backup of the MySQL 5.7 database or the entire host.
  3. Follow one of the official procedure that matches your environment, as described at https://dev.mysql.com/doc/refman/8.0/en/upgrading.html
  4. Upgrade License Statistics to v6.18 or above.
  5. Configure the new MySQL 8.0 database by copying the settings in License Statistics installation directory/mysql/my.ini, and adjusting the settings for your needs.
  6. Start License Statistics.
  • No labels