Knowledgebase Home / How to repair MySQL database from cPanel

How to repair MySQL database from cPanel

In this article, we will discuss how to check and repair databases from cPanel.

MySQL is one of the most widely used open-source relational database management systems that use SQL(Structured Query Language). A database can be called a collection of data, whereas an RDBMS like MySQL will store data in tables.

The MySQL tables can get corrupted which will stop the normal working of websites and produce errors for the visitors. There are some ways to check and repair the database. In this case, we will be looking at the steps that should be followed to repair the database from cPanel.

Quick Steps

1. Login to cPanel and open ​Mysql Databases
2. Select the database from the dropbox under Modify Databases Section.

3. Click on check database button for checking any errors.
4. Click on the repair database button to repair the database.

How to check and repair databases from cPanel?

Login to cPanel and locate Mysql databases under Databases section.

How to repair MySQL database from cPanel

Now select the databases you wish to check and repair from the drop-down box under Modify Databases Section. After selecting click on the Check Database button

How to repair MySQL database from cPanel

After clicking the check database button, the system will check the selected database for any errors and the errors will be displayed. After this, you can repair the database if any errors are displayed while checking. For repair, click on the Repair database button.

How to repair MySQL database from cPanel

Conclusion

Done! You have successfully repaired the selected database.

 

 

 

 

If the steps above listed in this article do not resolve your issue, please feel free to open a support ticket and we’d be happy to take a look.

Our Guiding Principles

  • Provide consistent, stable and reliable web hosting services.
  • Ensure rapid ticket response and quick resolutions to issues.
  • Never saturate or over-provision servers to ensure stability and speed for our customers.
  • Use only high quality enterprise-class hardware to ensure minimal downtime from hardware failures.
  • Provide clear pricing with no hidden fees or gotchas.