Move MySQL from an embedded host MySQL server to an external host:
- Install MySQL on a different, external host.
- Set the MySQL configuration option lower_case_table_names = 1. Important: You must perform this step prior to initializing/importing the database.
- Stop License Statistics.
- Backup the database.
- Restore the database on the new MySQL databaseexternal host (where you installed MySQL in step 1).
- Change the License Statistics configuration to use the new database (optional before moving installation).
- Start License Statistics (optional before moving installation).
Move the License Statistics installation:
- Contact X-Formation Support to request rehosting of the license.
- Stop License Statistics on the old host.
- Install License Statistics on the new host.
- Install Query Tools on query tools on the new host.
- Start License Statistics on the new host.
- Activate the license.