How To Repair Corrupted or Crashed MySQL Tables? [Hacks and Mods]
By on September 23rd, 2008

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

Tags: ,
Author: Keith Dsouza Google Profile for 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 and can be contacted at keith@techie-buzz.com.
  • http://www.mysql-database-recovery.com/ MySQL Repair

    Hi Keith,

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

    Thanks,

 
Copyright 2006-2012 Techie Buzz. All Rights Reserved. Our content may not be reproduced on other websites. Content Delivery by MaxCDN