We do support Round the Clock 24 x 7 x 365 (+91) 883 012 3924
 

Truncate exim database on cPanel server

Truncate exim database on cPanel server

Follow below steps to truncate all current eximstats tables :

# Login to SSH with root user
# Enter into MySQL server

# mysql

# Use the database eximstat.

mysql> use eximstats;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

# The DB eximstat mainly contains 4 tables:

mysql> show tables;
+---------------------+
| Tables_in_eximstats |
+---------------------+
| defers              |
| failures            |
| sends               |
| smtp                |
+---------------------+
4 rows in set (0.00 sec)

# Truncate all tables.

truncate table smtp;
truncate table sends;
truncate table failures;
truncate table defers;

# Quit from MySQL prompt.

mysql> quit
Bye

# Check the DB with mysqlcheck command

# mysqlcheck -c eximstats
eximstats.defers                                   OK
eximstats.failures                                 OK
eximstats.sends                                    OK
eximstats.smtp                                     OK

# Restart MySQL and Exim service

# service mysqld restart
# server exim restart

You can check this post to `Disable Eximstats database on cPanel server`.

 

Leave a Reply

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