WARNING: mysqlcheck has found corrupt tables

Discussion in 'Server Operation' started by nakeman, Oct 20, 2008.

  1. nakeman

    nakeman New Member

    When I log in to my acc via SSH, getting message "You have new mail". Opened mail and this is what I get:

    To: root@XXX root@XXX
    Subject: Re: WARNING: mysqlcheck has found corrupt tables

    What the *uck is wrong ? It started after couple of power failures. I think I get a new mail everytime when I boot my server.
    I'am using only SSH to config my server, so give me some shell commands pls.
  2. topdog

    topdog Active Member

    You need to repair the corrupt tables.
  3. nakeman

    nakeman New Member

    Well theres not a lot tables to repair. But is that shell command something like "repair <table>"?
  4. topdog

    topdog Active Member

    you do that for myisam tables from the mysql prompt

    mysql> repair table <table_name>
  5. nakeman

    nakeman New Member

    Why it keeps jamming...

    mysql> repair table ftpgroup

    I've changed database.
  6. topdog

    topdog Active Member

    It will run for some time u need to be patient depending on the size of the table.
  7. nakeman

    nakeman New Member

    I waited like 20min and on that table was only 1 row (or how it is called..).
  8. falko

    falko Super Moderator Howtoforge Staff

    You need to include a semicolon at the end of the command:
    repair table <table_name>[B][COLOR="Red"];[/COLOR][/B]
  9. nakeman

    nakeman New Member

    Thx! It works now (aka "Why didn't I sort that our by my own.. sigh)

Share This Page