- Plesk for Linux
The following error appears during a migration pre-check on the target server:
CONFIG_TEXT: In InnoDB 5.6 (both in MySQL 5.6 and MariaDB 10.0/10.1) server has variable innodb_strict_mode=0 by default.
So you can create table with wrong ROW_FORMAT option and warning will be reported.
In InnoDB 5.7 (both in MySQL 5.7 and MariaDB 10.2) server has variable innodb_strict_mode=1 by default.
Migration from source, hosted with previous version of InnoDB will not be possible to target
with current version of InnoDB and error will be issued if innodb_strict_mode is set to default.
Set variable innodb_strict_mode to OFF on target to avoid the migration errors.
Here is the link describing the problem
Here is a list of affected subscriptions:
MySQL version on the target server is newer than MySQL 5.7 or MariaDB 10.2.
# mysql -V
mysql Ver 15.1 Distrib 10.2.37-MariaDB, for Linux (x86_64) using readline 5.1
Strict mode is enabled on the newer versions of MySQL/MariaDB by default.
Note: Once the migration will finish, it is safe to enable back the
innodb_strict_mode option in Plesk Obsidian.
Connect to the target server via SSH.
innodb_strict_modeto MySQL configuration:
2.1. Open MySQL configuration file
/etc/my.cnfin a text editor, for example, in vi editor:
# vi /etc/my.cnf
Note: For Debian/Ubuntu the path is
innodb_strict_mode=OFFunder the [mysqld] section:
2.3. Save the changes and close the file.
Restart MySQL service:
# service mysql restart || service mariadb restart || service mysqld restart
Proceed with the migration.