Help Center> Data Replication Service> Troubleshooting> Solutions to Failed Check Items> Conflicts> Checking Whether Destination Database Contains the Same Table Names As the Synchronization Objects
Updated on 2022-09-21 GMT+08:00

Checking Whether Destination Database Contains the Same Table Names As the Synchronization Objects

MySQL > MySQL

Table 1 Checking whether destination database contains the same table names as the synchronization objects

Check Item

Whether destination database contains the same table names as the synchronization objects. (table name conflicts)

Description

The destination database contains objects with the same name as those in the source database. If table of the same name exists in the destination database, the migration cannot be performed.

Exceptions: If the names and structures of tables in the source and destination databases are the same, the system determines that no conflict occurs.

Failure Cause and Handling Suggestion

Failure cause: The source and destination database tables cannot have the same names.

Handling suggestions: Check whether the tables with the same names need to be retained. If yes, select another object for synchronization. If no, delete the tables with the same names.

Failure cause: The destination database contains the same table names as those of the synchronization objects.

Handling suggestions: Check whether the tables with the same names need to be retained. If yes, select another object for synchronization. If no, delete the tables with the same names.

Failure cause: Both the source and destination databases are RDS DB instance and do not have mapped databases.

Handling suggestion: Create mappings for the databases that are not mapped.