How do I optimize database tables in PHPMyAdmin?

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


  • Login to your cPanel account. Once logged in select the 'phpMyAdmin' icon.
  • From phpMyAdmin, select the database which contains the tables you'd like to optimize from the left hand column.
  • 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.
  • Click the dropdown for 'With Selected' and select 'Optimize Table'


That's it! This will optimize the tables you've selected.
  • 2 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Kapcsolódó cikkek

How to delete database table via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...

How do I rename a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on the "MySQL Databases"...

Delete a Database in cPanel

1. Log into your cPanel account.2. In the "Databases" section, click on the "MySQL Databases"...

Create a Database Username in cPanel

1. Log into your cPanel account.2. In the "Databases" section, click on the "MySQL Databases"...

Add a User to a Database with All Privileges

1. Log into your cPanel account.2. In the "Databases" section, click on the "MySQL Databases"...