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 Bu dökümanı faydalı bulan kullanıcılar:
Bu cevap yeterince yardımcı oldu mu?

İlgili diğer dökümanlar

How to Repair database via phpMyAdmin in cPanel?

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

How to optimize database via phpMyAdmin in cPanel?

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

Create a Database Username in cPanel

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

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 to export database table via phpMyAdmin in cPanel?

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