Versions Compared

Old Version 3

changes.mady.by.user Tomasz Ryba

Saved on

compared with

New Version 4

changes.mady.by.user Tracy McCurdy

Saved on

Key

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

Moving You can move the License Statistics installation between hosts on the same or different Operating Systems is possible operating systems, as described in the general steps below.

Warning
Moving from Windows to Linux is more complex and requires a different approacha more complex procedure than others. Please review all steps prior to moving the License Statistics installation from Windows to Linux.
Info

As of MySQL 8 changing , you cannot change the lower_case_table_names option is not possible after the database has been initialized/imported. Make sure to change the You must change this option on a clean installation , before restoring the database.  For more information about the lower_case_table_names option, see MySQL's website page.

This step is mandatory only when moving the It's a mandatory step when moving License Statistics installation from Windows to Linux only.


More information: https://dev.mysql.com/doc/refman/8
  1. .
0/en/identifier-case-sensitivity.html
More information: https://dev
  1. .
mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
From (old host)To (new host)DatabaseSteps
LinuxLinuxExternal
  1. Contact X-Formation Support to rehost request rehosting of 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 on the new host.
  7. Activate the license.
LinuxWindowsExternal
WindowsWindowsExternal
WindowsLinuxExternal

Change the MySQL configuration:

  1. Stop License StatsticsStatistics.
  2. Backup the database.
  3. Remove the database.
  4. Set the MySQL configuration option: option lower_case_table_names = 1. Important: You must perform this step prior to initializing/importing the database.
  5. Restore the database.
  6. Start License Statistics (optional before moving installation).

Move the License StatsticsStatistics installation:

  1. Contact X-Formation Support to rehost request rehosting of 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 on the new host.
  7. Activate the license
Info
LinuxLinuxEmbedded
  1. Contact X-Formation Support to rehost request rehosting of 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 on the new host.
  8. Activate the license.
LinuxWindowsEmbedded
WindowsWindowsEmbedded
WindowsLinuxEmbedded

Move MySQL from an embedded host to an external host:

  1. Install MySQL on a different host.
  2. Set the MySQL configuration option: option lower_case_table_names = 1. Important: You must perform this step prior to initializing/importing the database.
  3. Stop License StatsticsStatistics.
  4. Backup the database.
  5. Restore the database on the new MySQL database.
  6. Change the License Statistics configuration to use the new database (optional before moving installation).
  7. Start License Statistics (optional before moving installation).

Move the License StatsticsStatistics installation:

  1. Contact X-Formation Support to rehost request rehosting of 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 on the new host.
  6. Activate the license
Info