Difference between revisions of "Mysql check and repair tables"

Revision as of 19:31, 3 January 2008

If mysql is behaving oddly, check tables like this:

mysqlcheck -A -uuser -ppassword

Likewise, it may be able to repair corruption like this:

mysqlcheck --auto-repair -uuser -ppassword

or

mysqlcheck -r -uuser -ppassword