Mysql check and repair tables

From finninday
Revision as of 19:31, 3 January 2008 by Rday (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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