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.
Author: 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.Keith Dsouza has written 4378 articles for us.
The author of this post can be contacted at keith@techie-buzz.comComment Using Facebook
One Response to this Article | Share your Opinions/Comments
We moderate comments to prevent spam. Moderation is done within few hours. Please try and stay on topic and refrain from using abusive language. If you think there is a problem with this post, please email the post author or send us an email at tips@techie-buzz.com with the URL and the problem you see and we will rectify it as soon as we can.
Hi Keith,
Thank you for sharing with us. i will surely use the above procedure whenever face the mysql database corruption.
Thanks,