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
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 MySQL.
Change the view to the database that is failing in the error message:
ALTER TABLE mytable ROW_FORMAT=DYNAMIC;
Connect to the destination server and re-sync the subscription.