Can't create table idoit_data.table_name (errno: 140 "Wrong create options")

Problem

When restoring a SQL dump, the following error message occurs:

ERROR 1005 (HY000) at line 10381: Can't create table `idoit_data`.`table_name`
(errno: 140 "Wrong create options")

Cause

The dump contains tables with ROW_FORMAT=COMPRESSED, which is not supported by the target database configuration.

Solution

Before importing the dump, set the following database variables:

SET GLOBAL innodb_strict_mode = 0;
SET GLOBAL innodb_file_per_table = ON;

Then import the dump. After successful import, innodb_strict_mode can be re-enabled.

Detailed documentation: Troubleshooting in the Knowledge Base