How to repair a crashed database table in WHM

Introduction

An error similar to the following will be encountered when running a backup.

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

An error similar to the following may also be found in the MySQL error log.

[ERROR] /usr/sbin/mysqld: Table './db_name/table_name' is marked as
crashed and should be repaired

Sometimes, a MySQL database will be marked as crashed and require repair. The "Repair a MySQL® Database" interface in WHM can be used to repair a MySQL database.

Please note that the "Repair a MySQL® Database" interface does not support InnoDB tables.

Procedure

1. Log into WHM as the 'root' user.
2. Navigate to "Home / SQL Services / Repair a MySQL® Database."
3. Select the database to repair from the "MySQL Databases" list.
4. Click the "Repair Database" button.

Additional resources

Repair a MySQL Database