Help Center/ Data Replication Service/ User Guide (Ankara Region)/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the sql_mode Value in the Destination Database Is Not no_engine
Updated on 2024-04-11 GMT+08:00
View PDF
Share

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

MySQL Migration and Synchronization

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

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.
Parent topic: Database Parameters