vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/drs/umn/drs_11_0228.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

2.9 KiB
Raw Permalink Blame History

Checking Whether the sql_mode Value in the Destination Database Is Not NO_ENGINE_SUBSTITUTION

MySQL Migration and Synchronization

Table 1 Checking whether the sql_mode value in the destination database is not NO_ENGINE_SUBSTITUTION

Check Item

Whether the sql_mode value in the destination database is not NO_ENGINE_SUBSTITUTION

Description

MyISAM tables are included in the migration objects. The sql_mode value in the destination database cannot be NO_ENGINE_SUBSTITUTION.

Failure Cause and Handling Suggestion

Failure cause: The sql_mode value in the destination database is NO_ENGINE_SUBSTITUTION.

Handling suggestion: In the destination database, set SQL_MODE to a value other than NO_ENGINE_SUBSTITUTION. For details, see "Modifying Parameters" in the Relational Database Service User Guide.
Parent topic: Database Parameters