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

[Fli]

When i got this error:


DBD::mysql::db selectall_arrayref failed: Table './eximstats/sends' is marked as crashed and should be repaired at /usr/local/cpanel/Cpanel/DeliveryReporter/Basic.pm line 164.

I googled and based on the discovery, it seems that exims mysql table is crashed and so it needs to be repaired by mysqlcheck program.

So i executed following commands to fix the issue:

# mysqlcheck eximstats -repair -u root -p

Enter password:
eximstats.defers OK
eximstats.failures OK
eximstats.sends
warning : Number of rows changed from 47398 to 47397
status : OK
eximstats.smtp
warning : Number of rows changed from 35411 to 35403
status : OK

# /usr/local/cpanel/bin/updateeximstats

[imort]

When i got this error:
I googled and based on the discovery, it seems that exims mysql table is crashed and so it needs to be repaired by mysqlcheck program.


You get lucky or your table damage was relatively minor.
I can remember few problems when I can't fix that with 'mysqlcheck' utility and was needed to restore MySQL backup.

You can take a look to my article about how to set up a simple backup of your data and MySQL databases here (https://serversuit.com/community/technical-tips/view/basics-of-setting-up-a-backup-on-linux.html).