Help Center> Data Replication Service> User Guide (ME-Abu Dhabi Region)> 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 2023-02-02 GMT+08:00

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

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.