I'm helping a friend to backup his database, but I can't get it right doing standard mysqldump process, when I try to use mysqlcheck, I sort the result: http://pastie.org/9748430

'___') It's seriously scary..

Ok, now the question, how to make mysqldump ignore the error and continue backup till it's complete?

last error:

mysqldump: Couldn't execute 'show create table `xxx`': Table '.\mydb1\xxx' is marked as crashed and should be repaired (145)

1 Answer 1


Found it, using this flag:

--skip-lock-tables -f

The schema still can't be exported correctly, except by using phpmyadmin

  • 1
    Your database seems to be mostly corrupted. I recommend you to delete all your table files and reimport them. I also recommend you to use InnoDB instead of MyISAM to avoid further corruption problems in the future.
    – jynus
    Commented Nov 28, 2014 at 13:48
  • yes, it's wasn't me who design/administrate the server.. and yes, he is using MyISAM since 2011
    – Kokizzu
    Commented Nov 28, 2014 at 14:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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