Store
Community Documentation

v3 Knowledgebase

How to Repair a Crashed MySQL Table

Occasionally database tables become corrupt and you are no long able to access them.

Fortunately, you can often fix the table so you can access the data again.

In this tutorial, I would recommend you to use phpMyAdmin or the phpminiadmin.
Using phpMyAdmin

1) Login to phpMyAdmin

2) Choose the affected database.

3) In the main panel, you should see a list of your database tables.

4) Check the boxes by the tables that need repair.

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

Using phpminiadmin:

1) To upload the phpminiadmin in your website directory (I would recommend you to upload it in include/setting/).

2)Go to yourwebsite.com/include/setting/phpminiadmin.php

3) Login using the same credentials of your database website where it can be found at /include/setting/server.sett.php

4) Run the query:
repair table xxxxx

Where the xxxx means the database table crashed.

5) Very important to DELETE the phpminiadmin file.


Video Tutorial: