Use phpMyAdmin To Optimize Your Database

Luckily optimizing a MySQL database in phpMyAdmin is easy. In most cases, you won’t need to do this unless you have large databases that are constantly being changed. But if you do need to optimize your database follow these steps:

  1. Log into phpMyAdmin which you can find in your cPanel
  2. Choose the database by clicking on it in the left menu
    1. Make sure you’ve clicked on the database and not one of the tables
  3. Under the list of tables in your database you’ll see a “Check All” checkbox, tick this.
  4. You’ll then see a “With selected:” drop down, click it then choose “Optimize table”.


Did you find this article useful?   0 out of 0 people found this article useful.

Related Articles

  • Comments

Add Comment

Replying to  



Forgot password?
Register now