Before You Begin
（1） The version of the target self-built MySQL database is 5.1, 5.5, 5.6, 5.7, or 8.0.
（2） If you write fields in the columns whose names are different only in case forms into the same table in the target MySQL database, the migration may fail because column names in the MySQL database are case-insensitive.
Permission Requirements of Target Server
Migration Mode | Required Permissions |
Full | CREATE, SELECT, ALTER, INSERT, REFERENCES, INDEX, TRIGGER, CREATE VIEW, DROP, CREATE ROUTINE, EXECUTE |
Incremental | SELECT, INSERT, DELETE |
Auditing Repair | SELECT, INSERT, DELETE |
Configuration on Target Server
Data source type: Set this parameter to MySQL. The source database can be synchronized to MySQL databases within the version range.
Server IP: Specifies the IP address of the target database.
Port number: Specifies the port of the target database.
User name: Specifies a user name used to connect to the target database.
Password: Specifies the password of the user used to connect to the target database.
Database: Specifies the name of the database used by the target server to receive data from the source server.