The following error appears during a migration pre-check on the target server:
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:
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.
Add innodb_strict_mode to MySQL configuration:
2.1. Open MySQL configuration file
/etc/my.cnfin a text editor, for example, in the vi editor:
Note: For Debian/Ubuntu the path is /etc/mysql/my.cnf
innodb_strict_mode=OFF under 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.
- Connect to the target server via RDP.
- Open MySQL configuration file
%plesk_dir%DatabasesMySQLmy.iniin a text editor.
innodb_strict_mode=OFFunder the [mysqld] section:
2.3. Save the changes and close the file
Restart MySQL service via Plesk Services Monitor (it can be found in the system tray).
Proceed with the migration