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
- Failure Cause
- Handling Suggestion