Advertisement: Linux VPS from $4/month - contact support for custom offer.
+ Post New Thread
Results 1 to 2 of 2

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

  1. #1
    Administrator
    Join Date
    Mar 2013
    Posts
    2,724

    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
    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

Similar Threads

  1. Cartesian product of table ?
    By Sonamkumari in forum HTML,CSS, Javascript Coding & Programming
    Replies: 0
    Last Post: 09-21-2019, 06:05 AM
  2. Replies: 0
    Last Post: 09-10-2017, 01:30 PM
  3. Wordpress plugin to make comparison table?
    By Fli in forum Wordpress
    Replies: 0
    Last Post: 01-15-2016, 07:27 AM
  4. World cities / countries internet latency table
    By Fli in forum Dedicated Server Hosting
    Replies: 0
    Last Post: 11-15-2014, 08:55 AM
  5. Commands to search and replace in mysql table
    By Fli in forum PHP, MySQL Forum
    Replies: 1
    Last Post: 01-28-2014, 08:37 AM

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