RSS

MySql table repair

04 Jan

If you have a corrupted MySql database run this command to check all databases for corruption and report back only if there is corrupted tables (excluding session table)

mysqlcheck -s –all-databases

to repair all databases

mysqlcheck -r –all-databases

you can find mysqlcheck info at http://www.mysql.com/doc/en/Using_mysqlcheck.html

Advertisements
 
Leave a comment

Posted by on January 4, 2006 in Linux

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: