The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Errors

Discussion in 'General Discussion' started by trparky, Apr 19, 2005.

  1. trparky

    trparky Well-Known Member

    Joined:
    Apr 23, 2003
    Messages:
    184
    Likes Received:
    1
    Trophy Points:
    0
    DBD::mysql::db do failed: Can't open file: 'sends.MYI'. (errno: 145) at /usr/local/cpanel/cpanellogd line 1783.
    DBD::mysql::db do failed: Can't open file: 'sends.MYI'. (errno: 145) at /usr/local/cpanel/cpanellogd line 1784.
    DBD::mysql::st execute failed: Can't open file: 'sends.MYI'. (errno: 145) at /usr/local/cpanel/cpanellogd line 1786.
    DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/cpanel/cpanellogd line 1787.
    DBD::mysql::db do failed: Can't open file: 'sends.MYI'. (errno: 145) at /usr/local/cpanel/cpanellogd line 1792.

    What does this mean? Last time I checked, I was able to see what was in those Database Tables using PHPMyAdmin, so that doesn't seem to be a problem. So why the error?
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Looks like a problem with the eximstats db. I'd try WHM > MySQL > Repair a Database > eximstats > Repair Database
     
  3. anup123

    anup123 Well-Known Member

    Joined:
    Mar 29, 2004
    Messages:
    897
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    This Planet
    perror 145
    MySQL error: 145 = Table was marked as crashed and should be repaired

    So as Chirpy said, try repairing the same.
    Reasons for crash could be many. Most common one's are:

    a. MySQL not shut down properly - either mysqld hard killed, or server hard rebooted, or power loss.
    b. Disk i/o errors.
    c. Filesystem errors.
    d. Bug in mysql.

    Anup
     
Loading...

Share This Page