Linux command find and repair crashed tables

Discussion in 'Web Server' started by postcd, May 7, 2014.

  1. postcd

    postcd Member

    Messages:
    80
    Likes Received:
    6
    Trophy Points:
    8
    Hi, i got this message from my php script:


    So i want to ask how i can prevent site downtimes and what is the command i need to run on cronjob to check all mysql databases, find such buggy tables and repair them automatically?
  2. Rodrigo

    Rodrigo Member

    Messages:
    30
    Likes Received:
    11
    Trophy Points:
    8
  3. postcd

    postcd Member

    Messages:
    80
    Likes Received:
    6
    Trophy Points:
    8
    Thanks for contribution Rodrigo, but that command dont works to fix that table, this is what it return:
    MySQL Error : Incorrect key file for table './cashbb_vb/searchcore_text.MYI'; try to repair it
  4. mavankhang

    mavankhang New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    it is , like

Share This Page