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, 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