Restoration of a database fails in Plesk: errno: 140 “Wrong create options”

Symptoms

When importing a database or migrating it from another server, the database restoration fails with:

Can't create table `mydatabase`.`mytable` (errno: 140 "Wrong create options")
program 'mysql' finished with non-zero exit code: 1

Cause

InnoDB does not have the ROW_FORMAT FIXED option.

This is a MariaDB bug.

Resolution

In case of database import:

• Open the database dump in a text editor and replace all ROW_FORMAT=FIXED with ROW_FORMAT=DYNAMIC.

 

In case of migration:

1. Connect to the source server via SSH (Linux) / RDP (Windows Server).

2. Connect to MySQL.

3. Change the view to the database that is failing in the error message:

   use example_db;

4. Change the ROW_FORMAT to DYNAMIC:

   ALTER TABLE mytable ROW_FORMAT=DYNAMIC;

5. Connect to the destination server and re-sync the subscription.