First, you will need to login to shell as the root user. Run the following:

mysqlcheck —repair eximstats

If you receive, the below mentioned result. Once running this command then,

status: Operation failed

It means, it cannot be repaired and need to be recreated. So, run the following:

mysql
use eximstats;
drop table failures;

Then, run:

/usr/local/cpanel/bin/updateeximstats

This last line of command will fix the database scheme since you just dropped the "failure table". You can also "clear" the other databases to get a clean start. Just know that this will clear all of your current eximstats so if you have important stats you don’t want to be deleted, don’t clear the rest.

To clear the other stats, run:

mysql
use eximstats;
TRUNCATE TABLE sends;
TRUNCATE TABLE defers;
TRUNCATE TABLE smtp;
exit;

That’s it! 

Was this answer helpful? 0 Users Found This Useful (0 Votes)