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 2022-09-21 GMT+08:00

Checking Whether the Source Database Contains Invalid sql_mode Values

MySQL

Table 1 Checking whether the source database contains invalid sql_mode values

Check Item

Whether the source database contains invalid sql_mode values

Description

If the source database contains invalid sql_mode values, the migration will fail.

Failure Cause and Handling Suggestion

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.