Moving License Statistics installation between hosts on the same or different Operating Systems is possible as described in the general steps below.
Moving from Windows to Linux is more complex and requires a different approach.
As of MySQL 8 changing the lower_case_table_names option is not possible after the database has been initialized/imported. Make sure to change the option on a clean installation, before restoring the database.
It's a mandatory step when moving License Statistics installation from Windows to Linux only.
From (old host) | To (new host) | Database | Steps |
---|---|---|---|
Linux | Linux | External |
|
Linux | Windows | External | |
Windows | Windows | External | |
Windows | Linux | External | Change MySQL configuration:
Move License Statstics:
More information: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html |
Linux | Linux | Embedded |
|
Linux | Windows | Embedded | |
Windows | Windows | Embedded | |
Windows | Linux | Embedded | Move MySQL from embedded to an external host:
Move License Statstics:
More information: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html |