Fix all crashed tables in MySQL
Submitted by jasonn on September 6, 2010 - 11:41am
Have randomly crashed tables in your MySQL server and want to fix them all? This isn't the way to do it safely, but it's effective (if not very time consuming and CPU intense).
% mysqlcheck --auto-repair -A -urootusername -prootpassword
Just run the command mysqlcheck --auto-repair -A and add the credentials for a user that has privileges on all databases. Beware, there can be dire consequences. But, run a snapshot on your server and run this command if you want a quick fix.