Help Center/ Data Replication Service/ User Guide (Kuala Lumpur Region)/ Troubleshooting/ Solutions to Failed Check Items/ Database Objects/ Checking Whether the Source Database Tables Contain Primary Keys

Updated on 2022-08-16 GMT+08:00

View PDF

Checking Whether the Source Database Tables Contain Primary Keys

MySQL Migration

**Table 1** Checking whether the source database tables contain primary keys
Check Item	Whether the source database tables contain primary keys
Description	If tables to be migrated in the source database do not contain primary keys, the migration may fail.
Item to Be Confirmed and Handling Suggestion	Item to be confirmed: The tables to be migrated in the source database do not contain primary keys. Handling suggestion: Create a primary key for the table. If the table does not have a primary key to uniquely identify every row and the network connection is unstable, the data in the destination database may be inconsistent with that in the source database.

Parent topic: Database Objects

Previous topic: Checking Whether the Source Database Tables Use Storage Engines Not Supported by the Destination Database

Next topic: Checking Whether the Source Database Contains Triggers or Events

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.