Cloud Migration Service (CT-CMS)

Migrate from a Self-built MySQL Database to Another Self-built MySQL Database

2024-12-27 02:52:19

Before You Begin

(1) The target self-built MySQL database version is 5.1, 5.5, 5.6, 5.7, or 8.0 and the version is later than or the same as that of the source database.

(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 migrated to the 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.


U.AaOsnXP5RC