Difference between revisions of "Mysql check and repair tables"
From Finninday
Line 5: | Line 5: | ||
Likewise, it may be able to repair corruption like this: | Likewise, it may be able to repair corruption like this: | ||
− | mysqlcheck --auto-repair -uuser -ppassword | + | mysqlcheck -A --auto-repair -uuser -ppassword |
or | or | ||
− | mysqlcheck -r -uuser -ppassword | + | mysqlcheck -r databasename tablename -uuser -ppassword |
Latest revision as of 19:32, 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 -A --auto-repair -uuser -ppassword
or
mysqlcheck -r databasename tablename -uuser -ppassword