Clear eximstats DB in cPanel

How to clear eximstats DB

[dropcap]E[/dropcap]ximstats parses the Exim log to produce text and graphical data. You can find it at WHM »Email »Mail Delivery Reports. If you have noticed that the eximstats’ database is getting larger, then you can do the following steps to clear it.

Method 1:

Please login to the mysql

 
mysql

Once you login, please use the following commands to clear the eximstats table.

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

Method 2:

You can delete and create the eximstats database from command line. The steps are given below:

 
mysqladmin drop eximstats
mysqladmin create eximstats
mysql eximstats < /usr/local/cpanel/etc/eximstats_db.sql

That’s it!

If you like this post and wish to receive more articles from us, please like our FB page: Grepitout

Your suggestions and feedbacks will encourage us and help to improve further, please feel free to write your comments.

For more details on our services, please drop us an E-mail at info@grepitout.com