Here is a list of possible fixes to repair mysql databases.
Problem or Error:
warning : Table is marked as crashed and last repair failed
warning : 1 client is using or hasn't closed the table properly
warning : Size of indexfile is: 9275392 Should be: 1024
error : Can't read indexpage from filepos: -1
Error : Incorrect key file for table './dbname/tblname.MYI'; try to repair it
error : Corrupt
Solution:
myisamchk -r -v --force /data/mysql/dbname/tblname.MYI
Problem or Error:
Unable to Establish A Connection
Solution
Login to cPanel
Click Mysql Databases
Click Repair and then check database one at a time.
