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 Korisnici koji smatraju članak korisnim
Je li Vam ovaj odgovor pomogao?

Vezani članci

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

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

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