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 utilizatori au considerat informaţia utilă
Răspunsul a fost util?

Articole similare

How to edit database table via phpMyAdmin in cPanel?

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

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"...

Create a Database Username in cPanel

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

How do I rename a database in cPanel?

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

How do I connect to the MySQL database remotely?

To connect to your MySQL database remotely, you will need to login into your control panel and go...