Mysql check and repair tables

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