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 2023-05-23 GMT+08:00

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

MySQL Synchronization

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.

Item to be confirmed: The destination database contains tables whose SRIDs are different from those in the source database.

Handling suggestion: Check whether the geographic coordinate system used by the destination database table meets requirements. If the attribute of the geographic coordinate system has been specified at the source end, modify the structure of the destination database table to be the same as that at the source end.

MariaDB Synchronization

Table 2 Whether destination database contains the same table names as those of 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.