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/24 13:21 by tb
CC Attribution-Noncommercial-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0