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

Compare with Current View Page History

« Previous Version 6 Current »

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

Moving from Windows to Linux is a more complex procedure than others. Please review all steps prior to moving the License Statistics installation from Windows to Linux.

As of MySQL 8, you cannot change the lower_case_table_names option after the database has been initialized/imported. 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 License Statistics installation from Windows to Linux.


From (old host)To (new host)DatabaseSteps
LinuxLinuxExternal
  1. Contact X-Formation Support to 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 third-party query tools on the new host.
  6. Start License Statistics on the new host.
  7. Activate the license.
LinuxWindowsExternal
WindowsWindowsExternal
WindowsLinuxExternal

Change the MySQL configuration:

  1. Stop License Statistics.
  2. Backup the database.
  3. Remove the database.
  4. Set the MySQL configuration 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 Statistics installation:

  1. Contact X-Formation Support to 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 third-party query tools on the new host.
  6. Start License Statistics on the new host.
  7. Activate the license.
LinuxLinuxEmbedded
  1. Contact X-Formation Support to request rehosting of the license.
  2. Stop License Statistics on the old host.
  3. Backup the database.
  4. Install License Statistics on the new host.
  5. Restore the database on the new host.
  6. Install third-party query tools on the new host.
  7. Start License Statistics on the new host.
  8. Activate the license.
LinuxWindowsEmbedded
WindowsWindowsEmbedded
WindowsLinuxEmbedded

Move MySQL from an embedded MySQL server to an external host:

  1. Install MySQL on a different, external host.
  2. Set the MySQL configuration option lower_case_table_names = 1.
    Important: You must perform this step prior to initializing/importing the database.
  3. Stop License Statistics.
  4. Backup the database.
  5. Restore the database on the external host (where you installed MySQL in step 1).
  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 Statistics installation:

  1. Contact X-Formation Support to request rehosting of the license.
  2. Stop License Statistics on the old host.
  3. Install License Statistics on the new host.
  4. Install third-party query tools on the new host.
  5. Start License Statistics on the new host.
  6. Activate the license.


  • No labels