Home » Blogging Tips, Wordpress SEO & Plugins

Repair corrupted/crashed mysql tables via phpmyadmin

 September 20, 2008 3 Comments

Mysql database (db) tables may get corrupt and crash, due to several reasons.This article is on how to repair corrupted/crashed Mysql tables via phpMyAdmin. 

MySQL database(db) is known for its stability but as any other software application, there may be bugs that could crash the Mysql table/s. For eg: unstable operating system on which Mysql is installed could trigger the crash or it could even be that the hardware has problems or it could be as simple as a power failure. All this could lead to Mysql table crashes.However there is no reason to panick.It is easy to repair Mysql database (db) tables via phpMyAdmin.

How to repair Mysql tables via phpMyAdmin upon a corruption and crash?

When one or more Mysql tables get corrupt and crashes, they could be restored, by carrying out the below mentioned steps via phpMyAdmin: 

  • Login to phpMyAdmin
  • Select the affected mysql database. If you own only one database, then it would have been chosen by default
  • In the main panel, mysql tables for the database would be listed. Check the boxes besides the table/s that you want to repair.
  • At the bottom of the window (below the list of tables), you will find a drop down menu. Choose “Repair Table” from the menu

 

repair mysql db tables upon a corruption and crash
 
phpMyAdmin should automatically fix the chosen mysql tables. Once it is fixed, take a backup of the mysql database! Take regular backups of your mysql database (db) used in wordpress or any other application.

Related posts:
  1. How to optimize for overhead in mysql tables?
  2. Word Table – How To Create Tables In word 2007?
  3. Repair and Recover Corrupted Word Documents
  4. Backup your wordpress blog and upgrade to wordpress 2.3.2
  5. Does Custom query string plugin give “wp_categories doesn’t exist” database error?
  6. Zip recovery with free zip repair tool from DiskInternals
  7. Repair and fix broken AVI files with DivFix++
  8. How To Copy A Word Table to Excel worksheet?
  9. Wordpress 2.6 beta 1 is available for download
  10. How To change the display language for vista interfaces like welcome screen, wizards, menus, dialog boxes, Help topics etc. ?

Filed under: Blogging Tips Wordpress SEO & Plugins

3 Responses to “Repair corrupted/crashed mysql tables via phpmyadmin”

  1. Madhur Kapoor said:

    My tables crashed once as the Overhead got increased. Do you know what causes “Overhead” to develop in the tables

    # 21 September 2008 at 5:48 am
  2. Optimize for overhead in mysql (db) tables | Blogging Tips said:

    [...] Repair mysql tables via phpmyadmin upon a corruption and crash [...]

    # 21 September 2008 at 9:46 am
  3. techsea said:

    Thanks a lot for this tip.

    Helped me a lot.

    # 7 June 2009 at 10:50 am

Leave a Reply