[Resolved] Error "Eximstats is marked as crashed and should be repaired" MySQL error on Linux Server

This error occurs mainly when you are trying to check your email sent summary or email queue or any other function in your WHM panel.

148552 12:05:18 [ERROR] /usr/sbin/mysqld: Table './eximstats/sends' is marked as crashed and should be repaired
148552 12:05:18 [ERROR] /usr/sbin/mysqld: Table './eximstats/defers' is marked as crashed and should be repaired
148552 12:05:18 [ERROR] /usr/sbin/mysqld: Table './eximstats/failures' is marked as crashed and should be repaired
148552 12:05:18 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired

Click to expand...

To fix this error you have to follow the below steps.

1). Login to your cPanel server via SSH as root and run the below command to repair eximstats

Command : mysqlcheck -r eximstats

root@server [~]# mysqlcheck -r eximstats
eximstats.defers OK
eximstats.failures OK
eximstats.sends OK
eximstats.smtp OK

Click to expand...

If it gives this output :
status : Operation failed

Then it means it cannot be repaired and will need to be recreated.

mysql
use eximstats;
drop table failures;

Click to expand...

Then run this command :

# /usr/local/cpanel/bin/updateeximstats

Click to expand...