Site5 - Built For Designers & Developers MENU
Home  ›  Databases  ›  PHPMyAdmin  ›  phpMyAdmin: Optimize & Repair Tables

phpMyAdmin: Optimize & Repair Tables

Comments Off on phpMyAdmin: Optimize & Repair Tables

From time to time it is a good idea to do a some housekeeping within your applications or websites database. This is because MySQL, like your bedroom when you were a kid – does not clean itself. If you have a large database and have a lot of traffic to your website, you should optimize your tables regularly to ensure optimal database performance.

Note: WordPress users are able to install 3rd party plugins to will assist them in the optimization and repair process without the need for PHPMyAdmin.



 

Optimizing your database tables

We will be demonstrating how to optimize your MySQL tables.

Note: Some tables can not be optimized.

1) Log into your SiteAdmin or cPanel and select the PHPMyAdmin icon.

2) Select the database you wish to optimize.

3) Select the tables you wish to optimize. Or you can click the select all link located at the bottom of the table list.

4) Click the “with selected” drop-down menu, and select optimize.

 

5) After it completes optimize you will see the results of it on the next screen.

phpmyadmin_opt_1

 

That’s it! You should see a message confirming the requested operation.



 

How to repair database tables

Before we start a repair of a database table, we want to first check to see if we have to do it.

1) Log into your SiteAdmin/cPanel and select the PHPMyAdmin

2) Select the database you wish to check.

3) Select the tables you wish to check. Or you can click the select all link located at the bottom of the table list.

4) Select Check Table from the drop down list. If there is any errors in the results window, you will need to complete the repair process. In our example there is no errors.

phpmyadmin_repair_1

To Repair

Follow steps 1-3 from the Check Table process.

4) Select Repair Table from the drop down list. If errors persist after repair, contact our support team and we will be happy to investigate the matter on your behalf.

Still have a question? Or need help?
See an error in this article or want to suggest a missing topic? Please leave us a comment below! If you need technical support with your account, please email us, chat live with a representative, or call us!

Comments are closed.

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.