Let’s fix the pre-migration check finishes with an error issue in Plesk. With our Plesk Hosting Support, Bobcares offers solutions to your Plesk-related concerns.

How do we fix the “pre-migration check finishes with an error” in Plesk?

For Linux and Windows-based retail hosting service providers, Plesk is a commercial web hosting and server data center automation software. Plesk Web Admin Edition, Plesk Web Pro Edition, and Plesk Web Host Edition are the configurations that are offered. These are available for an upfront monthly or yearly fee.

We can easily manage a number of aspects of web hosting with Plesk. The tool offers some extra options in addition to the features found in every control panel.

Sometimes, during a migration pre-check on the target server, we may see the below error:

The reason behind the issue is the activation of Strict mode in newer MySQL/MariaDB versions by default. So we have to disable it. After the migration process completes, we can turn it on back.

Steps to fix the issue in Plesk

On Windows OS

1. Using RDP, connect to the target server.
2. Access the MySQL configuration file %plesk_dir%Databases\MySQL\my.ini in a text editor.
3. Include innodb_strict_mode=OFF under the [mysqld] section.

   [mysqld]
   innodb_strict_mode=OFF
   <...>
4. Close it after saving the changes.
5. Utilizing Plesk Services Monitor, restart the MySQL service.
6. Continue the migration.

On Linux OS

1. We can use SSH to connect to the target server.
2. In the MySQL configuration, include innodb_strict_mode.
3. Access MySQL configuration file /etc/my.cnf in a text editor:

   vi /etc/my.cnf
4. Under the [mysqld] section, include innodb_strict_mode=OFF:

   [mysqld]
   innodb_strict_mode=OFF
   <...>
5. Close the file after saving it.
6. Stop and start the MySQL service.

   service mysql restart || service mariadb restart || service mysqld restart
7. Continue the migration process.

[Are you searching for a solution to a different query? We’re here to help.]

Conclusion

The article explains the steps to fix the pre-migration check finishes with an error in Plesk. We provide separate steps for both Windows and Linux OS.