MySQL table repair

You may also like...

3 Responses

  1. MS says:

    MySQL tables can also repaired in the following way:

    mysql> use dtabase(ie in which database the table is includeed)

    mysql> REPAIR TABLE `tbl_name` to fix it!

  2. Vinoth says:

    Hi Guys, It is better and safer to repair the DB/Table via WHM/cPanel.

    If you want repair DB using myisamchk, you need to shutdown MySQL service before proceeding otherwise it will corrupt some other databases.

    Alternatively, if you do not want to shut down MySQL, you can use mysqlcheck.
    mysqlcheck [DBNAME]
    To repair the database tables:
    mysqlcheck -r [DBNAME]

    Correct me if I am wrong:P
    Happy Troubleshooting 🙂

  3. Anonymous says:

    you are right vinoth

Leave a Reply

Your email address will not be published.

3 × 2 =