How to check a MySQL database for errors in cPanel

Why check a database?

A database is where your website keeps its data. Tables are the parts inside it, like drawers in a cabinet. Sometimes a table gets damaged. This can happen after a crash or a full disk. A damaged table can cause blank pages or database errors on your site.

cPanel has two tools for this: Check DB and Repair DB. Check finds problems. Repair tries to fix them.

Warning: Take a backup before you repair anything. Repairs usually work, but a backup keeps you safe.

Check a database

1. Log in to your client area. Open your hosting service and log in to cPanel.
2. Under Databases, click MySQL Databases.

   

3. Scroll to the section named Modify Databases.
4. Next to Check DB, open the drop-down list.

   

5. Choose the database you want to test.
6. Click Check DB.

   

7. Wait for the result. Each table shows a status. OK means it is healthy.

Repair a database

If any table shows an error, repair it.

1. On the same page, find Repair DB.
2. Choose the same database from the list.
3. Click Repair DB.
4. Read the result. Healthy tables show OK.
5. Visit your website to see if the problem is gone.

Using phpMyAdmin instead

phpMyAdmin is a web tool to manage databases. You can open it from cPanel.

1. Open phpMyAdmin in cPanel.
2. Click your database name on the left.
3. Tick Check all.

   

4. In the With selected menu, choose Check table or Repair table.

Quick recap

• Damaged tables can break your site.
• Use MySQL Databases in cPanel, then Check DB and Repair DB.
• Back up first.
• phpMyAdmin offers check and repair as well.
• Ask support if errors stay.