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?