...
| The information on this page refers to License Statistics v6.24 or newer, which introduced support for MySQL 8.4. |
| Info |
|---|
| Note: We recommend that you make a backup of your database before performing any operations in order to avoid data loss or corruption. |
...
- As of April 30, 2025, MySQL 8.0 is no longer officially supported by the vendor.
- License Statistics versions older than v6.24 require MySQL 8.0.
- License Statistics v6.24 and newer require MySQL 8.4EMBEDDED databases need to be upgraded in order for License Statistics v6.24 to run.
- EXTERNAL External databases using MySQL 8.0 are deprecated, but will continue to work with with License Statistics v6.24.
- Embedded databases must be upgraded in order for License Statistics v6.24 to run.
| Info |
|---|
Support for MySQL 8.0 will be fully removed after April 30, 2025. |
...
| Note |
|---|
Direct update from MySQL 5.7 to MySQL 8.4 is not supported by the vendor. Thus ; therefore, it is not possible to update directly from the License Statistics prior to v6.18 to the License Statistics v24 v6.24 and above. Make sure you follow the official update procedure matching your scenario. For instructions on how to update MySQL 5.7 to MySQL 8.0, see Upgrading to MySQL 8. |
Upgrading the MySQL database
To upgrade either an embedded or external database, follow the instructions in Updating License Statistics.
The sections below outline the process for updating an embedded or external database.
Upgrading an
...
embedded MySQL database
If you are using an embedded MySQL database, you can perform a License Statistics upgrade procedure, in short:there is no requirement to update or create a new MySQL database. The upgrade procedure for an embedded MySQL database entails the following.
- Stop the old version (older than v6.1824) of License Statistics.
- Create a backup of the database (just in case it's needed).
- Upgrade License Statistics to v6.24 or above.
- 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 must 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 Although backing up and restoring the database is the easier solution, but can of the two methods, it may 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.
- Stop the old version (older than v6.24) of License Statistics.
- Create a backup of the database.
- Create a new external MySQL 8.4 instance.
- 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.
- Restore the database backup to the new MySQL 8.4 database.
- Upgrade License Statistics to v6.24 or above.
- Change the database credentials using License Statistics Manager or by editing the xflicstat.cfg file directly.
- Start License Statistics.
...
- Stop the old version (older than v6.24) of License Statistics.
- Create a backup of the database or the entire host.
- Follow one of the official procedures that match your environment, as described at https://dev.mysql.com/doc/refman/8.4/en/upgrading.html
- Upgrade License Statistics to v6.24 or above.
- 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.
- Start License Statistics.
...