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!
  • 21 Users Found This Useful
Was this answer helpful?

Related Articles

Setting up a Linux Streaming Server

Linux, streaming server Linux, allows you to stream video, audio or other media on your website....

How to Install LiteSpeed on a WHM/cPanel Server

Here’s how you install LiteSpeed on a WHM/cPanel Server – it should take about 25minutes from...

Change the default SSH port

The Secure Shell (SSH) Protocol by default uses port 22. Accepting this value does not make your...

Using VI Text Editor

Text editors are programs used to create or edit files. One of the most popular editors on...

Reset a MySQL root password

So you've managed to misplace your root login for a MySQL database? Not to worry, the following...