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.