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
Updated on 2024-11-30 GMT+08:00
View PDF
Share

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

During MySQL migration, 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

In the destination database, the sql_mode value is no_engine_substitution.

Handling Suggestion

In the destination database, set sql_mode to a value other than no_engine_substitution.

  • If the database is a self-managed MySQL database, run the following command to change the value. 
    SET sql_mode ='New value';
  • If the database is an RDS for MySQL DB instance, change the value of the sql_mode parameter by referring to Modifying Parameters of an RDS for MySQL Instance.
Parent topic: Database Parameters