There may be times when troubleshooting your website that you need to check and repair a database in cPanel using phpMyAdmin. This can help you identify and fix corrupted database errors on your website..
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.
Don’t have time to read our full article? Watch our walk-through video.
How to Check Your Tables
- Log into your cPanel
- Click the phpMyAdmin icon
- Choose the database you are working with by clicking on it in the left menu
- 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“
- 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
- Log into your cPanel
- Click the phpMyAdmin icon
- Choose the database you are working with by clicking on it in the left menu
- 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“
- The page will refresh and give you a summary of the tables that were repaired.
Congratulations, now you know how to check, and repair your database in phpMyAdmin. We also have a helpful guide on how to Check and repair databases in the MySQL Databases section of cPanel..