how to repair mysql dbs from ssh

Discussion in 'MySQL' started by ska_defender, Sep 3, 2010.

  1. #1
    Hello
    I have almost 50 databases and usually they corrupt anytime
    So I want to know is there any ssh command to repair all the db at once?
    Or any other way?
     
    ska_defender, Sep 3, 2010 IP
  2. Vicbowling

    Vicbowling Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Well I can't be more specific on the how (google can help) but you can copy over the database files with a recent backup OR import a recent backup sql file via the mysql command line. Either choice could be done via ssh and a script could be set up to go through all 50 however you'd want to code some good logging features into this because if something goes wrong here you need to know.
     
    Vicbowling, Sep 3, 2010 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    There is no one command (AFAIK) to repair all the databases at once. Actually you always repair a table not a database.
     
    mwasif, Sep 3, 2010 IP