MySQL is the most popular Open Source SQL database management system and is used by many popular website applications, such as WordPress, Joomla, and Drupal.
A MySQL database may require repair due to a crashed table or corrupted data. Here we cover the steps to perform a database repair from your cPanel.
Related Articles
Repair MySQL Database
- Log into cPanel
- Navigate to MySQL Databases, located under the Databases section
- Under Modify Databases, select the database that needs to be repaired from the Repair Database drop-down
TIP: If you are unsure of the correct database name, it can generally be found in the website's configuration file. Common configuration file locations:
CMS
Filename
WordPress wp-config.php Magento 1.x app/etc/local.xml
Magento 2.x app/etc/env.php
PrestaShop < 1.7 config/settings.inc.php
PrestaShop >= 1.7 app/config/parameters.php
Joomla configuration.php
Drupal sites/default/settings.php
- Click the Repair Database button