Checking MySQL databases
- Login to cPanel.
- Next, click phpMyAdmin under DATABASES section in the home screen.
- Then, choose the database you wish to check.
4. Choose the tables to be checked. Or you can click the select all link located at the bottom of the table list.
5. From the drop-down list, select Check Table. You will need to finish the repair process if there are any mistakes in the result window. In our example there is no errors.
Repairing MySQL databses
- Firstly, login to cPanel.
- Then, click phpMyAdmin under DATABASES section in the home screen.
- Choose a database to continue.
- Next, select the checkbox for the tables in the database that you want to repair.
- Lastly, click Repair Table. You will be informed by phpMyAdmin whether the repair process is successful or not.
Optimizing MySQL databases
- Firstly, login to cPanel.
- Then, click phpMyAdmin under DATABASES section in the home screen.
- Choose a database to continue.
- Next, select the checkbox for the tables in the database that you want to optimize.
- Lastly, click Optimize Table. You will be informed by phpMyAdmin whether the optimization process is successful or not.
We hope this article helped you to learn about how to check, repair and optimize MySQL table in phpMyAdmin. For more articles, please go to Knowledge Base.