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

6fdac60b24103e452edafa16ea3da42c5d64ee21?t=c29163d3f2265fc1fe2b0e6f7a6411aa


  Print

Share via


Comments


  Add Comment

Confirm Submission

Please enter the text from the image in the box provided, this helps us to prevent spam.