Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ERROR 1031 (HY000) at line 291001: Table storage engine for 'catalog_product_relation' doesn't have this option
- mysql -h localhost -u <user> -D <database> -p < <file>
- 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';
- sed -i 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql
- sed -i '' 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql
- LC_ALL=C sed -i '' 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement