How To Repair Corrupted or Crashed MySQL Tables? [Hacks and Mods]

Welcome to another hacks and mods article, in this one we look at a critical issue which many of use face once in a while, though the issue is trivial and seldom happens we have written a worthwhile tip to backup your database from the command prompt so do check it out.

If you are looking to repair corrupted MySQL tables, Techblissonline has a mod which we will be featuring today.

To repair a MySQL table follow the following steps:

  • Login to phpMyAdmin
  • Select the affected MySQL database.
  • In the options available from the check the tables you want to repair.
  • Navigate to the bottom of the page and select Repair Table from the menu.

This should run a rescue on the tables you selected for repair.

Mod Tip From Techblissonline

Published by

Keith Dsouza

I am the editor-in-chief and owner of Techie Buzz. I love coding and have contributed to several open source projects in the past. You can know more about me and my projects by visiting my Personal Website.I am also a social networking enthusiast and can be found active on twitter, you can follow Keith on twitter @keithdsouza. You can click on my name to visit my Google+ profile.

  • MySQL Repair

    Hi Keith,

    Thank you for sharing with us. i will surely use the above procedure whenever face the mysql database corruption.