How to rebuild exim stats database

Introduction

When the eximstats database becomes corrupt, it must be rebuilt. This article provides the procedure to rebuild the eximstats database.

Procedure

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Stop the tailwatchd service.

   /scripts/restartsrv_tailwatchd --stop

3. Stop eximstats service.

   /scripts/restartsrv_eximstats --stop

4. Move the eximstats databases out of the way.

   find /var/cpanel -name 'eximstats_db*' -exec mv -v {}{,.$(date +%s)} \;

5. Recreate the database

   /usr/local/cpanel/bin/updateeximstats

6. Import the Exim data.

   /scripts/import_exim_data /var/log/exim_mainlog

7. Regenerate the database.

   /scripts/slurp_exim_mainlog --force 

8. Restart the eximstats service.

   /scripts/restartsrv_eximstats

9. Restart the tailwatchd service.

   /scripts/restartsrv_tailwatchd --start