Versions Compared

Old Version 3

changes.mady.by.user Tomasz Ryba

Saved on

compared with

New Version Current

changes.mady.by.user Tomasz Ryba

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.

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

For License Statistics versions prior to v6.21, moving from Windows to Linux is a more complex

and requires a different approach.
Info

procedure than others. We recommend updating to License Statistics v6.21 or newer before moving the installation.

Moving License Statistics v6.21 and newer


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

rehost Query Tools new

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:

rehost
  • Configure License Statistics to use an external database
    • Install Query Tools new
    From (old host)To (new host)DatabaseSteps
    LinuxLinuxExternal
    1. Contact X-Formation Support to
    1. 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
    1. third-party query tools on the new host.
    2. Start
    1. License Statisticson the new host.
    2. Activate the license.
    LinuxWindowsExternal
    WindowsWindowsExternal
    WindowsLinuxExternal
    LinuxLinuxEmbedded
    1. Contact X-Formation Support to
    1. 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
    1. .
    2. Restore the database on the new host.
    3. Install third-party query tools on the new host.
    4. Start
    1. License Statisticson the new host.
    2. Activate the license.
    LinuxWindowsEmbedded
    Info
    More information: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
    WindowsWindowsEmbedded
    WindowsLinuxEmbedded


    Anchor
    moving_windows_to_linux
    moving_windows_to_linux
    Moving License Statistics versions older than v6.21 from Windows to Linux


    Info

    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.

    rehost Backup database
  • Restore the database on the new host
    • Install Query Tools new option:  Statstics new MySQL database Statstics rehost Query Tools on new More information: https://dev.mysqlcom/doc/refman/8.0/en/identifier-case-sensitivity.html
    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:

    		LinuxLinuxEmbedded

    1. Contact X-Formation Support to
    1. request rehosting of the license.
    2. Stop License Statistics on the old host
    1. .
    2. Install License Statistics on the new host
    1. .
    2. Configure License Statistics to use an external database.
    3. Install third-party query tools on the new host.
    4. Start
    1. License Statisticson the new host.
    2. Activate the license
    		Linux
    1. .
    WindowsEmbedded
    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
    1. option lower_case_table_names = 1.
      Important: You must perform this step prior to initializing/importing the database.
    2. Stop License
    1. Statistics.
    2. Backup the database.
    3. Restore the database on
    1. the external host (where you installed MySQL in step 1).
    2. Change the License Statistics configuration to use the new database (optional before moving installation).
    3. Start License Statistics (optional before moving installation).

    Move the License

    Statistics installation:

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