Advertisement: Linux VPS for $4/month - based on OpenVZ, credit card accepted, automatic setup.
+ Post New Thread
Results 1 to 2 of 2

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

  1. #1
    Administrator Fli's Avatar
    Join Date
    Mar 2013
    Posts
    2,421
    Post Thanks / Like
    Blog Entries
    1

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



    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

  2. #2
    Junior Member imort's Avatar
    Join Date
    Apr 2016
    Posts
    15
    Post Thanks / Like
    Quote Originally Posted by admin View Post
    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.

+ Post New Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
 Protected by : ZB BLOCK  &  StopForumSpam