I'm getting some error from Magento MySQL database. I tried to fix it from "Magento Database Repair Tool" , unfortunately it shows "reference DB doesn't seem to be a valid Magento database". Please tell me, how can I fix it.
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
This problem appears to occur when you're importing a table definition that had been created with MyISAM but later was switched to InnoDB; the resulting ROW_FORMAT options appear to be invalid.
If you're trying to import an exported database and encounter this problem, you can simply search and replace
ROW_FORMAT=FIXED with nothing.
I used the following to do so really quickly:
sed -ie 's/ROW_FORMAT=FIXED//g' backup.sql
Run this command in directory with file.sql
ROW_FORMAT=FIXED option from CREATE TABLE DDL will fix the issue. So let’s try possible solutions.
sed -i 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql
This didn’t work for me in MacOSx which resulted in the following error:
sed: 1: “magento-db-dump.sql”: invalid command code m
sed -i '' 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql
And even this resulted as:
sed: RE error: illegal byte sequence
LC_ALL=C sed -i '' 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql