Magento – Problem when importing a database using SSH: ERROR 1031 (HY000): Table storage engine doesn’t have this option

Picture

We were just a database via SSH command ( mysql -h localhost -u Nutzer -pPASSWORT DB-NAME < backup.sql) import into a database. We were after a short time but again and again the error

ERROR 1031 (HY000) at line 3757: Table storage engine for ‘catalog_product_relation’ doesn’t have this option

This error is natural for most users slightly different but basically the same problem.

It helped here directly in the SSH command

sed -ie 's/ROW_FORMAT=FIXED//g' backup.sql

enter and confirm. Then, the dump is to “ROW_FORMAT=FIXED” searched and selbiges then sacked without compensation.

Then the import worked then without demolition.

Published by Covos

Since 2009 I have been working intensively with Magento. I started with the creation and operation of B2C stores. This was extended through my work in the logistics sector. This resulted first specialized B2E systems. Today I work day-a day with exciting B2C, B2B- and B2E projects and reports in this blog about challenges and give insider tips.

Leave a Reply

Your email address will not be published. Required fields are marked *