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 …

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