0

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.

Please Help.

  • Show please your code and code error – Evgeniy Kapelko Jul 7 '18 at 12:33
  • are you trying to make an import? – Evgeniy Kapelko Jul 7 '18 at 19:52
  • yes, i was uploading some product for test. – yakee Jul 8 '18 at 6:53
  • sir, how can i fix it.? please help. – yakee Jul 8 '18 at 6:57
1

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

Removing ROW_FORMAT=FIXED option from CREATE TABLE DDL will fix the issue. So let’s try possible solutions.

1

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

2

sed -i '' 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql

And even this resulted as:

sed: RE error: illegal byte sequence

3 But this one worked for me in MacOSx

LC_ALL=C sed -i '' 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql
  • if I helped you, choose my answer as correct – Evgeniy Kapelko Jul 8 '18 at 17:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.