Help Center>
Data Replication Service>
Troubleshooting>
Solutions to Failed Check Items>
Database Parameters>
Checking Whether the sql_mode Value in the Destination Database Is Not NO_ENGINE_SUBSTITUTION
Updated on 2022-09-21 GMT+08:00
Checking Whether the sql_mode Value in the Destination Database Is Not NO_ENGINE_SUBSTITUTION
MySQL Migration and Synchronization
Check Item |
Whether the sql_mode value in the destination database is not NO_ENGINE_SUBSTITUTION |
|---|---|
Description |
MyISAM tables are included in the migration objects. The sql_mode value in the destination database cannot be NO_ENGINE_SUBSTITUTION. |
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. |
Parent topic: Database Parameters
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
