Cleaning large eximstats mysql database : Cpanel/WHM

by rajesh 2012-05-01 19:26:11

If you are using cpanel/WHM you can go to /var/lib/mysql and use "du -sch *" command to find the mysql disk usage of each database accounts.

If the size of your eximstats database is getting large, you will have to do this.

Login as root in to your server using ssh.

Login to mysql
#mysql

#use eximstats

Then from with the query browser run

>delete from sends;
>delete from smtp;
>delete from failures;
>delete from defers;

Now use df to check the free disk space.
6670
like
0
dislike
0
mail
flag

You must LOGIN to add comments