Linux command find and repair crashed tables

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

  1. postcd

    postcd Member

    Joined:
    Apr 16, 2014
    Messages:
    121
    Likes Received:
    10
    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

    Joined:
    Jul 19, 2013
    Messages:
    31
    Likes Received:
    11
  3. postcd

    postcd Member

    Joined:
    Apr 16, 2014
    Messages:
    121
    Likes Received:
    10
    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

    Joined:
    Jun 3, 2014
    Messages:
    5
    Likes Received:
    0
    it is , like
     

Share This Page