It's B

Tag: database

  • 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