How to check and repair broken MySQL ISAM
tables
If you are stuffed with errors in
/var/log/mysqld.log
similar to:
110711 11:00:48 [ERROR] /usr/libexec/mysqld: Incorrect
information in file:
'./anyboots_moncler_spaccio/zen_seo_cache.frm'
110711 11:00:48 [ERROR] /usr/libexec/mysqld: Incorrect information
in file:
'./anyboots_moncler_spaccio/zen_sessions.frm'
This is a sure sign something terrible has happened with your mysql
database tables that lead to corruption.
Having corrupt table in mysql installation can severely lead to
data loss as well as significantly reduce the speed and performance
of a MySQL server in this awful times
mysqlcheck is the best
friend of the administrator, here is how you can check and repair
broken tables in MySQL server:
mysql-server:~# mysqlcheck --all-databases -u root -p
chillor_hjbgl.vn_users OK
chillor_lul.mybb_adminlog OK
chillor_lul.mybb_adminoptions OK
chillor_lul.mybb_adminsessions OK
chillor_lul.mybb_adminviews OK
chillor_lul.mybb_announcements OK
...
You will notice the corrupt sql tables will be reported as corrupt
by the tool and mysqlcheck will try it's best to recover the
corrupt tables.
In most cases this should be enough to recover corrupt
tables.