Mysql check and repair tables: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| 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