当您从MySQL 5.5.x导出Magento数据库转储并尝试在MySQL 5.7.x中导入时,您可能会遇到错误:
这可能是由于您在CREATE TABLE DDL中具有的表选项:ROW_FORMAT = FIXED
让我们来检查SQL转储中是否有这样的字符串(例如:magento-db-dump.sql)
cat magento-db-dump.sql | grep '=FIXED'
其结果是:
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Catalog Product Relation Table';
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Catalog Product To Website Linkage Table';
从CREATE TABL