Personal & Business Web Hosting in CanadaWeb Hosting from $2.95Domain Name Registration CanadaWeb Hosting CanadaTechnology News and Business News from BCwebnetHelpdesk, FAQ, Sales & Client Support PortalComputers, Printers, Supplies, Servers & Memory
You are here: Support > Knowledgebase > How-To > How to optimize a MySQL database using phpMyAdmin? Please Login or Register



How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized.

Fortunately, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel.

To perform the optimization, log in to your phpMyAdmin and select the database whose tables you wish to optimize.

A list with all the database's tables will appear. Tick the tables you wish to optimize, or simply click [Check All] to select all tables.

Click the box [With selected:] and choose Optimize table. This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.



Was this answer helpful?

Add to Favourites
Print this Article

BCwebnet
Language:

home web hosting domains affiliates about us support blog shop

bcwebnet.com © 1999 - 2009 | Privacy Policy | Terms Of Use | Contact Us