1. Home
  2. Computing & Technology
  3. PHP / MySQL

Repairing a MySQL Database with phpMyAdmin
How to fix a database table that is corrupted using phpMyAdmin

By Angela Bradley, About.com

Occasionally database tables become corrupt and you are no long able to access them. It is a good idea to always backup your information incase it can't be restored. Fortunately, you can often fix the table so you can access the data again. Doing this in phpMyAdmin is a fairly simple process.

  1. Login to phpMyAdmin

  2. Choose the affected database. If you only have one database, it should choose it by default so you don't need to do anything.

  3. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.

  4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose "Repair Table"

This should fix your table, and let you access it again. Now that it is fixed... it's a good idea to make that database backup!

More PHP / MySQL Quick Tips
Explore PHP / MySQL
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. Learn MySQL
  5. MySQL Administration
  6. Repair MySQL - Repair Table phpMyAdmin - Repair MySQLTable

©2009 About.com, a part of The New York Times Company.

All rights reserved.