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



  • 150 Users Found This Useful

Was this answer helpful?

Related Articles

Error: rpmdb open failed with cPanel

Fixing RPM Database Errors in cPanel   The error "rpmdb open failed" occurs when the RPM...

VPS Time not Correct with Time Server

VPS Time Not Syncing With Time Server   If the time on your VPS is incorrect or drifting,...

FSCK Options and Maintenance

Provided below are some useful commands pertaining to FSCK. Update commands to your environment /...

cPanel Account - PHP Startup: Unable to load dynamic library

PHP Startup Error: Unable to Load Dynamic Library   The error "PHP Startup: Unable to load...

Repairing and Optimizing all MySQL and MariaDB Databases on the Server

From time to time you will find repairing and optimizing your databases are necessary. From a...



Save 30% on web hosting - Use coupon code Hosting30