Checking Whether the SQL_MODE Values of the Source and Destination Databases Are the Same

MySQL

Table 1 Checking whether the SQL_MODE values of the source and destination databases are the same

Check Item

Whether the SQL_MODE values of the source and destination databases are the same

Description

Check whether the SQL_MODE values of source and destination databases are the same. If they are inconsistent, the migration may fail.

Failure Cause and Handling Suggestion
  • If you are migrating data to the cloud, perform the following operations:

    Failure cause: The SQL_MODE values of the source and destination databases must be the same.

    Handling suggestion: Change the SQL_MODE values of the destination database to the same as those of the source database, Ensure that both the source and destination databases do not have the forbidden SQL_MODE values. For details, see "Modifying Parameters in a Parameter Group". If MyISAM tables are to be migrated, the SQL_MODE values in the destination database cannot contain NO_ENGINE_SUBSTITUTION.

  • If you are migrating data out of the cloud, perform the following operations:

    Item to be confirmed: The SQL_MODE values of the source and destination databases must be the same.

    Handling suggestions: Change the SQL_MODE values of the destination database to the same as those of the source database. Ensure that both the source and destination databases do not have the forbidden SQL_MODE values.
Parent topic: Database Parameters