Shutdown mysql:

[html]
/etc/init.d/mysql stop
[/html]

Change into database directory:

[html]
cd /var/lib/mysql/dbname
[/html]

Check and repair MYI tables:

[html]
myisamchk -o -r *.MYI
[/html]

-o – safe recover

-r – recover

Written by Matt Cooper
Hi, I'm Matt Cooper. I started this blog to pretty much act as a brain dump area for things I learn from day to day. You can contact me at: matt@matthewc424.sg-host.com.