Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database Contains Invalid sql_mode Values
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Checking Whether the Source Database Contains Invalid sql_mode Values

During MySQL migration, the source database cannot have invalid values of sql_mode. Otherwise, the migration may fail.

Failure Cause

The sql_mode value of the source database cannot be no_engine_substitution.

Handling Suggestion

Change sql_mode of the source database to a proper value.

  • 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