How do I optimize database tables in PHPMyAdmin?

To optimize database tables in phpMyAdmin please use the following process:

1) Login to either cPanel or the Web Host Manager. Once logged in select the 'phpMyAdmin' icon.

2) From phpMyAdmin, select the Database which contains the tables you'd like to optimize from the left hand column.

3) Select the tables that you would like to optimize by clicking the checkbox to the left of the database table, or Select All at the bottom to include all tables

4) Click the dropdown for 'With Selected' and select 'Optimize Table'

That's it! This will optimize the tables you've selected.

  • 12 Users Found This Useful
Was this answer helpful?

Related Articles

cPanel and WHM Information

You can find excellent documentation for cPanel/WHM on the developers' site here:...

Where/what is the license I purchased?

The license you purchased is applied upon server creation. If for some reason this is not the...

How do I enable the GD library on a cPanel server?

First you will need to login to the Web Host Manager, Select Software->EasyApache If your...

Do you provide DNS management?

Yes, there are two primary options for managing DNS for your domains on a cPanel server: Option...

Install PageSpeed Module on cPanel Server

First we clone the content from GitHub: /usr/local/cpanel/3rdparty/bin/git clone...