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.

Помог ли вам данный ответ?

 Распечатать статью

Также читают

Account Migration

To generate the backup (on the server you are moving the account from) 1. Login to cPanel. 2....

How do I create a new cPanel account within the Web Host Manager?

1. On the left hand navigation of WHM scroll down to Packages, and select Add Packages. Create a...

How can I change the SMTP port on a cPanel server?

Login to the Web Host Manager => Service Configuration => Service Manager, you'll find an...

cPanel Self Signed Certificates & Warnings

cPanel uses self-signed SSL certificates by default when you connect to the server for...