MysqlDump with ignore errors 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)
Found it, using this flag:

--skip-lock-tables -f


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