Checking Whether the sql_mode Value in the Destination Database Is Not no_engine
MySQL Migration and Synchronization
Check Item |
Whether the sql_mode value in the destination database is not no_engine |
---|---|
Description |
If the MyISAM tables are included in the migration objects, the sql_mode value in the destination database cannot be no_engine_substitution. Otherwise, the migration fails. |
Failure Cause and Handling Suggestion |
Failure cause: The sql_mode value in the destination database is no_engine_substitution. Handling suggestion: In the destination database, set sql_mode to a value other than no_engine_substitution. For details, see Modifying Parameters in the Relational Database Service User Guide. |
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