Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database Contains Invalid sql_mode Values
Updated on 2025-12-17 GMT+08:00
Checking Whether the Source Database Contains Invalid sql_mode Values
During MySQL migration, the source database cannot have invalid values of sql_mode. Otherwise, the migration may fail.
Failure Cause
The sql_mode value of the source database cannot be no_engine_substitution.
Handling Suggestion
Change sql_mode of the source database to a proper value.
- If the database is a self-managed MySQL database, run the following command to change the value.
SET sql_mode ='New value';
- If the database is an RDS for MySQL DB instance, change the value of the sql_mode parameter by referring to Modifying Parameters of an RDS for MySQL Instance.
Parent topic: Database Parameters
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
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.
For any further questions, feel free to contact us through the chatbot.
Chatbot