Fix – ERROR 1031 Table storage engine for ‘table_name’ doesn’t have this option

Sometimes you get the below error while importing the database.

ERROR 1031 (HY000) at line 5643 in file: '/Users/username/Downloads/database.sql': Table storage engine for 'table_name' doesn't have this option

Now let’s fix this.

Step – 1

Open your sql file in your favourite editor and go to SQL query of that table.

You will see ROW_FORMAT=FIXED at the last of the query and remove that.

Step – 2

Save your file and try to import the database. This should fix the error.


That’s it