Checking Whether the sql_mode Values of the Source and Destination Databases Are the Same
Check whether the sql_mode values of the source and destination databases are the same. If they are different, the migration may fail. You are advised to change them to the same value.
Failure Cause
The sql_mode values of the source and destination databases must be the same.
Handling Suggestion
- If the database is a self-managed MySQL database, run commands 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.
If MyISAM tables are to be migrated, the sql_mode values in the destination database cannot contain no_engine_substitution.
For details about how to change the value of sql_mode for other types of databases, see the usage guide of the corresponding database.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot