How to rebuild exim stats database

Question

How to rebuild exim stats database?

Answer

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

1. Access the server's command line as the root user via SSH or Terminal in WHM.

2. Stop the tailwatchd service.

   # /usr/local/cpanel/scripts/restartsrv_tailwatchd --stop

3. Stop eximstats service.

   # /usr/local/cpanel/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.

   # /usr/local/cpanel/scripts/import_exim_data /var/log/exim_mainlog

7. Restart the eximstats service.

   # /usr/local/cpanel/scripts/restartsrv_eximstats

8. Restart the tailwatchd service.

   # /usr/local/cpanel/scripts/restartsrv_tailwatchd --start