Repairing Mysql Tables

Just going about day by day tasks, out network monitoring solution is acting very funky.

Sure enough, some of the .MYI files are missing.  This is a really simple fix that for some reason other people I know couldn’t find a way to fix.  To fix these issues, there is a simple command but first you might as well check to see if there are other errors.  So start by using the mysqlcheck utility.

mysqlcheck -A –auto-repair

This will tell you what tables are fubar’d

To repair them log into mysql and run the following command.

repair table <tablename> use_frm;

I’ve read the use_frm is often unnecessary, but to my experience its always required when mysqlcheck can’t fix them automagically.

Leave a Reply