1. Computing

Repairing a MySQL Database with phpMyAdmin

How to fix a database table that is corrupted using phpMyAdmin

By

Repairing a MySQL Database with phpMyAdmin
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!

See More About
  1. About.com
  2. Computing
  3. PHP / MySQL
  4. Learn MySQL
  5. MySQL Administration
  6. Repair MySQL - Repair Table phpMyAdmin - Repair MySQLTable

©2014 About.com. All rights reserved.