Versions Compared

Old Version 1

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.

From (old host)To (new host)DatabaseSteps
LinuxLinuxExternal
  1. Contact X-Formation Support to
rehost
  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
Query Tools
  1. third-party query tools on the new host.
  2. Start
new
  1. License Statisticson the new host.
  2. 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:

LinuxLinuxEmbedded
  1. Contact X-Formation Support to
rehost
  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
  • Configure License Statistics to use an external database
    • Install Query Tools
    1. on the new host.
    2. Start
    new
    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.

    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
    rehost
    1. request rehosting of the license.
    2. Stop License Statistics on the old host
    Backup database
    1. .
    2. Install License Statistics on the new host
  • Restore the database on the new host
    • Install Query Tools
    1. .
    2. Configure License Statistics to use an external database.
    3. Install third-party query tools on the new host.
    4. Start
    new
    1. License Statisticson the new host.
    2. Activate the license
    Linux
    1. .
    Windows
    EmbeddedWindowsWindowsEmbeddedWindows
    LinuxEmbedded

    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: 
    1. option lower_case_table_names = 1.
      Important: You must perform this step prior to initializing/importing the database.
    2. Stop License
    Statstics
    1. Statistics.
    2. Backup the database.
    3. Restore the database on
    new MySQL database
    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

    Statstics

    Statistics installation:

    1. Contact X-Formation Support to
    rehost
    1. 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
    1. third-party query tools on the new host.
    2. Start
    new
    1. License Statisticson the new host.
    2. Activate the license
    InfoMore information: https://dev.mysql
    1. .
    com/doc/refman/8.0/en/identifier-case-sensitivity.html