Monday, 10 December 2012

eximstats database

Clearing eximstats database:

If you would like to clear eximstats database:

#mysql


#use eximstats;

Then run the below query to clear the tables.

>delete from sends;
>delete from smtp;
>delete from failures;
>delete from defers;

Sometime the above tables shows as crashed like,

Table './eximstats/sends' is marked as crashed and should be repaired

In this situation, try below command to check "sends" table,

# cd /var/lib/mysql/eximstats/

#myisamchk /var/lib/mysql/eximstats/sends.MYI

to repair table : # myisamchk /var/lib/mysql/eximstats/sends.MYI -r


Remove eximstats:

If you would like to remove and recreate eximstats database,

emptied the tables like this:
# > table.MYD

or

# cd /var/lib/mysql/eximstats/

# rm -rf *

# cd

# mysql

> DROP DATABASE eximstats;
> CREATE DATABASE eximstats;
> quit

# mysql eximstats < /var/cpanel/sql/eximstats.sql

Thats it .....

1 comment:

  1. Thanks, it has fixed one of my issue.

    ReplyDelete