empty the eximstats database via the MySQL command line while the MySQL service is down

Database Dedicated Server Solution Linux Command

You’re not able to empty the eximstats database via the MySQL command line while the MySQL service is down. I moved away the eximstats database by running the following command:

mv -v /var/lib/mysql/eximstats /home/cptechs/

Your server’s / partition has free space now:

=====

[email protected] ~]cPs# df -h /
Filesystem Size Used Avail Use% Mounted on
/dev/md2 20G 15G 4.4G 77% /

=====

I then restarted the MySQL service and regenerated an empty eximstats database by running the following commands:

/scripts/restartsrv_mysql
/usr/local/cpanel/bin/updateeximstats

The MySQL service is now up and running:

=====

[email protected] ~]cPs# service mysql status
SUCCESS! MySQL running (3493)

[email protected] ~]cPs# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2004
Server version: 5.5.42-cll MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

=====

You may want to consider reducing the amount of days that the eximstats database retains data for at:

WHM » Server Configuration » Tweak Settings » Stats and Logs » The interval, in days, to retain Exim stats in the database

Leave a Reply

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