Versions Compared

Old Version 1

changes.mady.by.user Tomasz Ryba

Saved on

compared with

New Version 2

changes.mady.by.user Tomasz Ryba

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

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
Info
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
Info
More information: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html