myisamchk

What to to if your MYISAM tables have been corrupted somehow?

  • stop mysql
  • move to your data directory
  • move into the database directory you want to fix
  • run the following command:
for i in  *.MYI ; do myisamchk --recover $i ; done
  • repeat the step above for all your database directories you want to fix
  • restart mysql
  • good luck :-?
mysql/myisamchk.txt · Last modified: 2009-04 by tb
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0 ipv6 ready