A database is an organized collection of data & information. It can be accessed, managed and updated as per the user’s need. Over the period of time, database can get corrupted and you need to repair it. Sometimes, you may need to examine and repair the database when you are troubleshooting your site. In this tutorial, you will learn how to examine and repair a corrupted database in phpMyAdmin.
Prerequisites
- cPanel Access credentials
Step 1:
Login to your Cpanel and locate phpMyAdmin under Database.
Click on phpMyAdmin to access the dashboard of phpMyAdmin. Choose the database you need to examine and repair by clicking on the left side menu. You will see a list of tables from your database. Click on the Operations Tab.
Step 2:
Inside the Maintenance, scroll down to the Table Maintenance box at the bottom and click Check Table or Repair Table as required.
Step 3:
You can also the SQL Tab to check & repair the table. For this click on the SQL Tab.
You need to run SQL query for both checking and repairing the table. The basic SQL query for checking and repairing table is :
CHECKTABLE`mrr_posts` REPAIRTABLE`mrr_comments`
The names inside is the ` ` table name. You need to add your table name and execute the query by clicking the Go button.
Conclusion:
By following these above steps, you can successfully examine and repair your database in phpMyAdmin. Next time when you need to troubleshoot your site, make you sure you examine and repair your database too.
Check out the top 3 cPanel hosting services:
- Your query to the best web hosting can end by clicking on this link.
