On this page
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

Checking Whether the sql_mode Value in the Destination Database Is Not NO_ENGINE_SUBSTITUTION

Updated on 2022-09-21 GMT+08:00

MySQL Migration and Synchronization

Table 1 Checking whether the sql_mode value in the destination database is not NO_ENGINE_SUBSTITUTION

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.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback