Clear cPanel Eximstats DB and Repairing the Eximstats DB

Over the time or due to spammers the eximstats database file may grow to a large size. To clear it run the following commands:


mysql
use eximstats
delete from sends;
delete from smtp;
delete from failures;
delete from defers;
quit



To quickly repair the eximstats database run the following:


service mysql stop
myisamchk -r /var/lib/mysql/eximstats/*.MYI
service mysql start




Share this page:


Was this article useful? Have any suggestions or improvements to the information?

Also Read

Manually Clear from Console / Command Line cPanel Exim Mail Queue

To clear the cPanel exim mail queue quickly from a command line / shell use the following...

SpamAssassin Command Line Bayesian Learn Command cPanel

Once it is enabled, it is necessary to train spamassassin to learn what is junk mail and what is...

central_filter defer (-17): error in filter file: unknown filtering command "r_subject:" near line 22 of filter file

The error "central_filter defer (-17): error in filter file: unknown filtering command...

VPS Time not Correct with Time Server

If you have a problem with your VPS time not staying sync in a Xen VPS you will want to enable...

Permission denied: /home/username/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable

When checking your error log you find the error 508 or 403 forbidden error in your browser and...