You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


The information on this page refers to License Statistics v6.24 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 April 30, 2025, MySQL 8.0 is no longer officially supported by the vendor.
  2. License Statistics versions older than v6.24 require MySQL 8.0
  3. License Statistics v6.24 and newer require MySQL 8.4
  4. EMBEDDED databases need to be upgraded in order for License Statistics v6.24 to run.
  5. EXTERNAL databases using MySQL 8.0 are deprecated but will continue to work with License Statistics v6.24. 

Support for MySQL 8.0 will be fully removed after April 30, 2025.

Direct update from MySQL 5.7 to MySQL 8.4 is not supported by the vendor. Thus it is not possible to update directly from the License Statistics prior to v6.18 to the License Statistics v24 and above. 

Make sure you follow the official update procedure matching your scenario.

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 database (just in case it's needed).
  3. Upgrade License Statistics to v6.24 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.4.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 or 8.0 database can be successfully restored on MySQL 8.4.

  1. Stop the old version (older than v6.24) of License Statistics.
  2. Create a backup of the database.
  3. Create a new external MySQL 8.4 instance.
  4. Configure the new MySQL 8.4 database by copying the settings in License Statistics installation directory/mysql/my.ini, and adjusting the settings for your needs.
  5. Restore the database backup to the new MySQL 8.4 database.
  6. Upgrade License Statistics to v6.24 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.24) of License Statistics.
  2. Create a backup of the database or the entire host.
  3. Follow one of the official procedures that match your environment, as described at https://dev.mysql.com/doc/refman/8.4/en/upgrading.html
  4. Upgrade License Statistics to v6.24 or above.
  5. Configure the new MySQL 8.4 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