I'm trying to make a new development version of our Magento store.
I made a clean install of El Capitan and got apache running with PHP, Mysql(version 5.7.10) etc. I also have phpmyadmin running and created a database for Magento. However, when I try to import the backup from our production site I get the error:
ERROR 1031 (HY000) at line 291001: Table storage engine for 'catalog_product_relation' doesn't have this option
I tried to import the .sql file through the Terminal with the command:
mysql -h localhost -u <user> -D <database> -p < <file>
I'm lost here. Google for quit some time but couldn't find the solution.
I'm using the same engine as in the production databse.
Anyone have any idea's?
Best Answer
Recently, I had the same problem with the import.
PROBLEM
This is probably due to the table option that you have in your CREATE TABLE DDL:
ROW_FORMAT=FIXED
Let’s check if there is any such string in the SQL dump (Ex: magento-db-dump.sql).
Which resulted as
SOLUTION
Removing
ROW_FORMAT=FIXED
option from CREATE TABLE DDL will fix the issue. So let’s try possible solutions.#1
This didn’t work for me in MacOSx which resulted in the following error:
#2
And even this resulted as:
#3 But this one worked for me in MacOSx
(source)