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

During MySQL migration, if the MyISAM tables are included in the migration objects, the sql_mode value in the destination database cannot be no_engine_substitution. Otherwise, the migration fails.

Failure Cause

In the destination database, the sql_mode value is no_engine_substitution.

Handling Suggestion

In the destination database, set sql_mode to a value other than no_engine_substitution.

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

Предыдущая статья

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

Следующая статья

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

Была ли эта статья полезна?

Поддержка Юридические документы