How to Check and Repair a Database

There may be times when troubleshooting your website that you need to check and repair tables in your database, as they may have become corrupt.

Before continuing, be sure that you make a backup of the database you are working with in the event this does not resolve your issue.

How to check your tables

1. Log into your cPanel
2. Click the phpMyAdmin icon
3. Choose the database you are working with by clicking on it in the left menu
4. On the right side of the page, you will see a listing of your tables. Click "Check All" and then from the drop down choose "Check Table"
   
5. The page will refresh and give you a summary of table that may be corrupted. As you can see from the screenshot below, all the tables are OK. If you receive any errors, you can continue reading to find how to repair your tables.
   

How to repair your tables

1. Log into your cPanel
2. Click the phpMyAdmin icon
3. Choose the database you are working with by clicking on it in the left menu
4. On the right side of the page, you will see a listing of your tables. Click "Check All" and then from the drop down choose "Repair Table"
   
5. The page will refresh and give you a summary of the tables that were repaired.