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/
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
>
> quit
# mysql eximstats < /var/cpanel/sql/eximstats.sql
Thats it .....
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 .....
Thanks, it has fixed one of my issue.
ReplyDelete