cPanel: How to Check and Repair Corrupted Database

cPanel: How to Check and Repair Corrupted Database

In this Article Jump to: Check Database Repair Database Make a Backup

 

Chances are you are running a PHP based web application like WordPress which uses a Database to store Posts, Pages and other content for your website. PHP applications are constantly writing to the Database. During the interaction between the Web Based PHP Application and the Database there are times that something can go wrong. When something goes wrong during this interaction it can lead to database corruption. When the database becomes corrupted you will usually see an error on the front page. In this article, we will discuss How to Check and Repair a Corrupted Database in cPanel.

 

BEFORE making any changes: Make a Backup of Your Databases

Before making ANY changes to your databases you must always make a backup! Your Database is a separate entity from your Website files all-together. It’s great to have a backup of your website files but this does NOT include the database. There are separate steps to take in order to backup your databases.

Click Here for our Guide: How to Make a Backup of your Databases in cPanel

 

Locating the Name of the Database for your Application

If you have more than one website that uses a database, you will need to locate the name of which database you’ll need to check and repair.

Click Here for our Guide: How to Locate Your WordPress Database: wp-config.php

 

How to Check Your Database for Corruption

You can check your Database for Corruption easily using the Check Database Tool in cPanel. Follow the steps below to check your Database for corruption.

Step 1. Log into cPanel

Step 2. Under the ‘Databases‘ section Click on the ‘MySQL Databases‘ icon

how to check and repair your databases in cpanel

Step 3. In the ‘Modify Databases‘ section of cPanel, Click on the Drop-Down menu and Select the name of the Database you want to Check under the ‘Check Database‘ section.

how to check your database for corruption in cpanel

Step 4. With the correct Database name selected, click on the blue ‘Check‘ button to initiate the check.

cpanel check mysql database for corruption

Step 5. In our Example our Database is OK. But you will see something different here if it’s corrupted and cPanel will list the corrupted tables for you. Once you’ve confirmed the database is corrupted, you can then Repair it using the Repair tool.

cpanel check and repair database

Step 6. Click on the Blue ‘Go Back‘ link to Return to the ‘Modify Database‘ section of cPanel.

 

How to Repair Your Corrupted Database

You can repair your Corrupted Database easily using the Repair Database Tool in cPanel. Follow the steps below to Repair your corrupted database.

Step 1. Log into cPanel

Step 2. Under the ‘Databases‘ section Click on the ‘MySQL Databases‘ icon

how to check and repair your databases in cpanel

Step 3. In the ‘Modify Databases‘ section of cPanel, Click on the Drop-Down menu and Select the name of the Database you want to Repair under the ‘Repair Database‘ section.

how to repair wordpress database

Step 4. With the correct Database name selected, click on the blue ‘Repair‘ button to initiate the Repair.

repair cpanel database

Step 5. If the Database was successfully repaired you will see a green message “Repair Complete” indicating the Database has been repaired successfully.

how to repair a corrupted database

 

That’s it! You’ve learned how to Check and Repair a Corrupted Database using the Tools in your cPanel hosting account.

If you are still experiences issues with the database after a successful repair, there may be another issue. Reach out to our Friendly Support Team for help.

 

How useful was this post?

Let us know what you think!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Thanks for rating our post!

Don't forget to follow us on Facebook for more great tips. https://www.facebook.com/glowfrog

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?