How to check and repair a MySQL database through phpMyAdmin?

If your database is performing slowly or you notice errors similar to "table crashed" you may need to run some MySQL maintenance through phpMyAdmin or cPanel. In this article, we will show you how to run a full check and repair of your database within phpMyAdmin using just a few simple clicks.

Step 1: Login to cPanel

Step 2: Once you’re logged in, locate the "Databases" section of cPanel. Within, there is an icon for "phpMyAdmin". Click on the “phpMyAdmin" icon.

Step 3. In “phpMyAdmin” screen select the database you would like to check and repair using the left menu.

Step 4. You will see a listing of your tables. Click "Check All" or use the check box to select specific tables and then from the drop down labelled “With Selected” choose "Check Table".

Step 5. The page will refresh and give you a summary of table that may be corrupted. If you receive any errors, you can continue to Step 6 to find how to repair your tables.

Step 6. From the listing of tables click "Check All" or use the check box to select specific tables and then from the drop down labelled “With Selected” choose "Repair Table".

Step 7. The page will refresh and give you a summary of the tables that were repaired.

Was this useful? Share it!

UK REGISTERED COMPANY 11074916 |
Copyright © 2019 - Solelyweb Ltd - All Rights Reserved |