Symptoms
Sometimes, a MySQL database will be marked as crashed and require repair. WHM backups or the MySQL error log will indicate as such.
cpbackup.log:
Cpanel::Exception::ProcessFailed::Error/(XID redctd) “/usr/bin/mysqldump”
reported error code “3” when it ended: mysqldump: Error 1194: Table
'db_options' is marked as crashed and should be repaired when dumping
table `db_options` at row: 150
MySQL error log:
[ERROR] /usr/sbin/mysqld: Table './db_name/table_name' is marked as
crashed and should be repaired
Description
There are several causes for database tables to crash.
Workaround
There are a few ways to repair a database table and which one works depends on the type of table or crash. Through the cPanel & WHM interfaces, there are two solutions:
WHM's Repair a MySQL Database can be used to attempt to repair database tables that may have become corrupt.
cPanel's MySQL Databases also contains a "Repair Database" button.
If cPanel & WHM's interfaces are unable to repair a database, you will want to reference your version of MySQL's reference manual for guidance on table repair.