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

Add custom filter for searching post or users in WordPress backend

For this, two parts are important. Part 1: Adding select dropdown Below is the action by which we can add a new search filter for…

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.

Fix – ERROR 2006 (HY000) while importing database in MySQL

While importing big database in MySQL, you might get the error as shown below: ERROR 2006 (HY000) at line 3387 in file: ‘path_to_the_db_dump.sql’: MySQL server…

Edit old commit message on github

Sometimes we make mistake in git commit message, especially spelling mistake. Even though I think twice before pressing the enter key after I write the…

PHPCode Sniffer + Sublime on windows

Things you need for: cmder composer Sublime Text 2/3 We are going to install using composer, because it will automatically install related packages. So no…

Responses

Leave a Reply