Home » WHM/cPanel » How to resolve “Table ‘./eximstats/sends’ is marked as crashed and should be repaired

How to resolve “Table ‘./eximstats/sends’ is marked as crashed and should be repaired

If you see the error on mysql log ” /usr/sbin/mysqld: Table ‘./eximstats/sends’ is marked as crashed and last (automatic?) repair failed”

To fix issue “Table ‘./eximstats/sends’ is marked as crashed and should be repaired ” please perform the issue

#myisamchk -r /var/lib/mysql/eximstats/TABLENAME.MYI

OR
Disable eximstats from whm >> Service Manager

root@server [~]#mysql -u username -p
mysql> use eximstats ;
Database changed
mysql> show tables ;

Then truncate all the tables,
mysql> truncate table smtp;
Query OK, 0 rows affected (7.43 sec)

mysql> truncate table sends;
Query OK, 0 rows affected (4.60 sec)

mysql> truncate table defers;
Query OK, 0 rows affected (0.02 sec)

mysql> truncate table failures;
Query OK, 0 rows affected (0.11 sec)

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

restart mysql and exim

#service mysql restart
#server exim restart

About

I am founder and webmaster of www.linuxpcfix.com and working as a Sr. Linux Administrator (Expertise on Linux/Unix & Cloud Server) and have been in the industry from last 7 years.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Time limit is exhausted. Please reload the CAPTCHA.

Categorized Tag Cloud