(mt):Repairing a crashed MySQL database table with phpMyAdmin

  • This page was last modified on December 17, 2011, at 16:02.
The (mt) Community Wiki is a collaborative project. Any (mt) Media Temple customer or employee may contribute. Not all articles and/or content have been tested for accuracy by (mt) Media Temple.

For officially moderated and tested articles, be sure to visit our KnowledgeBase.

From (mt) Community Wiki

Have you ever loaded your website, only to see a message saying that a table has been "marked as crashed and should be repaired"? This MySQL database error looks scary, and for many people, they think they've lost everything. Well, GOOD NEWS everyone! Though this can happen for a number of reasons, the fix is relatively quick, and will have your site back online in no time.

Contents

Before We Begin

This entry is written with the understanding that the reader already knows how to access phpMyAdmin on their (gs) Grid-Service or (dv) Dedicated-Virtual Server. If you do not, please read one of the following (mt) Wiki entries before proceeding:

phpMyAdmin on the (gs) Grid-Service
phpMyAdmin on the (dv) Dedicated-Virtual Server

What a crashed table looks like.

Repairing The Table

1. Choose the database you want to work with from the left hand column.
2. Click the check box on the table line that shows "In Use" (see image to the right).
3. Below all table entries, there is a drop-down menu called "with selected", choose the "repair table" option (see image to the right).
4. Wait patiently as the MySQL server repairs the table. The operation may take a while to complete, depending on the size of the table.
5. Once done, you will see a results page appear, hopefully with the word" OK" next to your table's status.
6. ♪ Celebrate ♪

Related Articles

Exporting and importing MySQL databases on the (gs) Grid-Service
Exporting and importing MySQL databases on the (dv) Dedicated-Virtual Server

Retrieved from "http://wiki.mediatemple.net/w/(mt):Repairing_a_crashed_MySQL_database_table_with_phpMyAdmin"