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

For License Statistics versions prior to v6.21, moving from Windows to Linux is a more complex procedure than others. We recommend updating to License Statistics v6.21 or newer before moving the installation.

Moving License Statistics v6.21 and newer


This section also applies to License Statistics versions prior to v6.21, except when moving License Statistics from Windows to Linux, which is described in the next section.

Follow the steps given in the table below to move License Statistics v6.21 or newer from one host to another.

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
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


Moving License Statistics versions older than v6.21 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.

Follow the steps given in the table below to move License Statistics versions older than v6.21 from one host to another.

From (old host)To (new host)DatabaseSteps
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.
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