- Plesk for Linux
- Plesk for Windows
When importing a database or migrating it from another server, the database restoration fails with:
CONFIG_TEXT: Can't create table `mydatabase`.`mytable` (errno: 140 "Wrong create options")
program 'mysql' finished with non-zero exit code: 1
InnoDB does not have the
ROW_FORMAT FIXED option.
This is a MariaDB bug.
In case of database import:
Open the database dump in a text editor and replace all
In case of migration:
Connect to the source server via SSH (Linux) / RDP (Windows Server).
Connect to MySQL.
Change the view to the database that is failing in the error message:
MYSQL_LIN: use example_db;
MYSQL_LIN: ALTER TABLE mytable ROW_FORMAT=DYNAMIC;
Connect to the destination server and re-sync the subscription.
Please sign in to leave a comment.