While trying to import the Magento database in my MySQL 5.7.31 version, I faced an error which read  “Table storage engine for ‘catalog_product_relation’ doesn’t have this option”

So here I’m sharing with you how we can easily solve this import error.

For Linux & Window run the below command before using the .sql file for import:

sed -i '' 's/ROW_FORMAT=FIXED//g' your-database.sql

For Mac run the below command before using the .sql file for import:

LC_ALL=C sed -i '' 's/ROW_FORMAT=FIXED//g' your-database.sql

Now you are importing your-database.sql successfully.