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

Compare with Current View Page History

Version 1 Next »

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)DatabaseSteps
LinuxLinuxExternal
  1. Contact X-Formation Support to rehost the license
  2. Stop License Statistics on the old host
  3. Install License Statistics on the new host
  4. Configure License Statistics to use an external database
  5. Install Query Tools on the new host
  6. Start new License Statistics
  7. Activate the license
LinuxWindowsExternal
WindowsWindowsExternal
WindowsLinuxExternal

Change MySQL configuration:

  1. Stop License Statstics
  2. Backup database
  3. Remove database
  4. Set MySQL configuration option: lower_case_table_names = 1
  5. Restore database
  6. Start License Statistics (optional before moving installation)

Move License Statstics:

  1. Contact X-Formation Support to rehost the license
  2. Stop License Statistics on the old host
  3. Install License Statistics on the new host
  4. Configure License Statistics to use an external database
  5. Install Query Tools on the new host
  6. Start new License Statistics
  7. Activate the license
More information: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
LinuxLinuxEmbedded
  1. Contact X-Formation Support to rehost the license
  2. Stop License Statistics on the old host
  3. Backup database
  4. Install License Statistics on the new host
  5. Restore the database on the new host
  6. Install Query Tools on the new host
  7. Start new License Statistics
  8. Activate the license
LinuxWindowsEmbedded
WindowsWindowsEmbedded
WindowsLinuxEmbedded

Move MySQL from embedded to an external host:

  1. Install MySQL on different host
  2. Set MySQL configuration option: lower_case_table_names = 1
  3. Stop License Statstics
  4. Backup database
  5. Restore database on new MySQL database
  6. Change License Statistics configuration to use new database (optional before moving installation)
  7. Start License Statistics (optional before moving installation)

Move License Statstics:

  1. Contact X-Formation Support to rehost the license
  2. Stop License Statistics on the old host
  3. Install License Statistics on the new host
  4. Install Query Tools on the new host
  5. Start new License Statistics
  6. Activate the license
More information: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html


  • No labels