---
title: How to Check or Repair a MySQL Database?
description: "🌐This guide is also available in Arabic[← اقرأ بالعربية](https://kb.tarweig.com/docs/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d9%81%d8%ad%d8%b5-%d9%88%d8%a5%d8%b5%d9%84%d8%a7%d8%ad-%d9%82%d9%88%d8%a7%d8%b9%d8%af-%d8%a8%d9%8a%d8%a7%d9%86%d8%a7%d8%aa-mysql-%d8%b9%d8%a8%d8%b1-cpanel-%d8%a3%d9%88/) This tutorial details how to check for error or repair a MySQL database through cPanel or phpMyadmin. This can easily be done by following the steps listed in this step by…"
url: "https://kb.tarweig.com/en/docs/how-to-check-or-repair-mysql-database/"
updated: "2026-10-11"
category: Hosting Management
---

# How to Check or Repair a MySQL Database?

🌐This guide is also available in Arabic[← اقرأ بالعربية](https://kb.tarweig.com/docs/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d9%81%d8%ad%d8%b5-%d9%88%d8%a5%d8%b5%d9%84%d8%a7%d8%ad-%d9%82%d9%88%d8%a7%d8%b9%d8%af-%d8%a8%d9%8a%d8%a7%d9%86%d8%a7%d8%aa-mysql-%d8%b9%d8%a8%d8%b1-cpanel-%d8%a3%d9%88/)

This tutorial details how to check for error or repair a MySQL database through cPanel or phpMyadmin. This can easily be done by following the steps listed in this step by step article.

### Though cPanel

**1)** **[Log into cPanel](https://kb.tarweig.com/en/docs/login-cpanel-whm-account/)**.

**2)** Look for the “**DATABASES**” section and click on **“MySQL® Databases”**.

 

[![](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/cPanel-Databases-MySQL®-Databases-1024x354.png)](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/cPanel-Databases-MySQL®-Databases.png)
cPanel > Databases > MySQL® Databases

**3)** Look for the **“Modify Databases”** section, here you can either check for errors or repair a MySQL database. Select the database you want to **check** from the drop down menu and click on the “**Check Database**” button.

To **repair** a corrupted database just the database you want to check from the drop down menu and click on the “**Repair Database**” button.

 

[![](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/cPanel-MySQL®-Databases-1024x334.png)](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/cPanel-MySQL®-Databases.png)
Modify Databases > Check or Repair database

A new interface will appear and the system will attempt to automatically check/repair the database. If the system cannot repair the database, it will attempt to determine the source of the corrupt data.

That’s it! Now you know how to check or repair database tables through cPanel.

### Through phpMyAdmin

**1)** [Log into cPanel](https://kb.tarweig.com/en/docs/login-cpanel-whm-account/).

**2)** Look for the “**DATABASES”** section and click on “phpMyAdmin”. You’ll be redirected to the phpMyAdmin interface.

[![](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/cPanel-Databases-phpMyAdmin-1024x300.png)](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/cPanel-Databases-phpMyAdmin.png)
cPanel > Databases > phpMyAdmin

**3)** From this new screen, we have direct access to all the databases created under this cPanel account, they are all listed on the left side.

[![](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/phpMyAdmin-interface-1024x342.png)](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/phpMyAdmin-interface.png)
phpMyAdmin interface

**4)** Select the database you wish to check or repair.

**5)** You will now see all the database’s tables. Select the table(s) you wish to check or repair, or simply click **Check All** to select all tables.

[![](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/Select-database-in-phpMyAdmin-1024x276.png)](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/Select-database-in-phpMyAdmin.png)
Select database > Tick ‘Check All\]’ to select all tables

**6)** Click the drop-down **With selected: **\]and choose ***Check table** or ****Repair**table***. This will execute the *CHECK/**REPAIR TABLE* SQL query on the selected tables and they will be checked or repaired.

[![](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/checkrepair-table-in-phpMyAdmin-1024x276.png)](https://kb.tarweig.com/wp-content/uploads/kb-media/2017/02/checkrepair-table-in-phpMyAdmin.png)
Click the drop-down With selected: and choose Check table or Repair table

**That’s it! Now you know how to check or repair database tables through phpMyAdmin.**