The migration process for MySQL Server

Prerequisites

Source and target SQL Server instances must be installed.

The target SQL Server instance must have at least the same version as the source instance. A downgrade is not supported!

Using command prompt

In the commands, configuration files, or SQL statements below, please always replace:

SRCHOST with the address of the source database server

SRCROOTLOGIN with the source MySQL server root user login

SRCEEIDBNAME with the name of the source EEI Server database to back up

TARGETHOST with the address of the target database server

TARGETROOTLOGIN with the target MySQL server root user login

It is not necessary to execute the SQL statements below via the command line. If there is a GUI tool available, you can use an application you already know.

You can run the commands from the Source or Target machine if those machines are in the same network and ping between those machines is working. If they are not in the same network, you have to manually move the backup file to the target machine.

1.Stop the EEI Server service.

2.Navigate to C:\Program Files\MySQL\MySQL Server 5.7\bin or C:\Program Files\MySQL\MySQL Server 8\bin based on the MySQL version you have installed.

3.Create a full database backup of the source EEI Server database (the database you plan to migrate):

example

Example

mysqldump --host SRCHOST --user=SRCROOTLOGIN --password --events --opt --routines --triggers --databases SRCEEIDBNAME --default-character-set=utf8mb4 --result-file="C:\USERS\public\BACKUPFILE.sql"

4.Enter root login password. You can also do it by adding it directly after --password parameter ( --password=ABCD ).

5.Adjust the my.ini file on the target machine based on the version of MySQL you are using. Version 5.7 or 8.

6.Restore the database on the target MySQL server.

example

Example

mysql --host TARGETHOST --user=TARGETROOTLOGIN --password < "C:\USERS\public\BACKUPFILE.sql"

7.Enter root login password. You can do it as well by adding it directly after -p parameter ( -pABCD ).

8.Run the ESET EEI Server service if the target MySQL Server machine keeps the same IP address and name of the database as the Source one.

9.When you migrate the database to another server (MySQL IP or port are changed) or change database name (MySQL IP and port are the same, but database name changed), you have to re-setup the EEI Server by using the "Repair/Change" option in the Installer. Leave all the settings as they are, but change the database settings like MySQL IP, port, or database name.