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

Related Articles

Install wp-cli on windows

WP-CLI is a set of command-line tools for managing WordPress installations. You can update plugins, configure multisite installs and much more, without using a web browser.

So I am going to tell you short, simple and easy way that how to use wp-cli on windows system.