Magento – SSH Database Import – Problem ERROR 1031 (HY000) at line 2623: Table storage engine for ‘catalog_product_relation’ doesn’t have this option

Picture

We have just tried a database dump via SSH (Putty) to play to a new server and received the error: “ERROR 1031 (HY000) at line 2623: Table storage engine for ‘catalog_product_relation’ doesn’t have this option“.

This seems to regard a problem. to be MySQL, if previously an update has been made. We helped the SQL file with a simple text editor (e.g.. PSPad) to open and then with the “Search and replace”-search function following text:

PictureROW_FORMAT=FIXED;” (including. Spaces and excl. “”). This text then replace “;” (only one ; no spaces or “”).

Then import the SQL file again via SSH-Import. Now it should work without problems.

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 *