vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/drs/umn/drs_11_0060.html
Wang , Deng Ke 5523220f09 DRS UMN 20221102 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com>
Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
2022-12-08 10:16:13 +00:00

4.3 KiB
Raw Permalink Blame History

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

MySQL Migration

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

Check Item

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

Description

Check whether the innodb_strict_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 innodb_strict_mode values of the source and destination databases must be the same.

    Handling suggestion: Create a parameter group for the destination database and change innodb_strict_mode to the same value as that of the source database. For details, see Creating a Parameter Group in Relational Database Service User Guide.

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

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

    Handling suggestion: Change innodb_strict_mode of the destination database to the same value as that of the source database.
Parent topic: Database Parameters