Databases
Welcome to the SaHost Support Centre
< Back
Print
BySaHost

To optimize the database via phpMyAdmin in cPanel, follow these steps:

  1. Log in to your cPanel account.
  2. In the Databases section, click phpMyAdmin.
  3. In the left-hand sidebar, click the database that you want to optimize.
  4. At the bottom of the list of tables, select the Check All checkbox.
  5. In the With selected list box, select Optimize table.
  6. Click the Go button.

phpMyAdmin will optimize the selected tables in the database. Once the optimization is complete, you will see a confirmation message.

Here are some additional tips for optimizing the database via phpMyAdmin in cPanel:

  • It is recommended to optimize the database regularly, especially if it is a large database or if it is used frequently.
  • You can also optimize individual tables in the database by selecting the tables that you want to optimize and then clicking the Optimize table button.
  • If you are having trouble optimizing the database, you can try using the Repair table function.
BySaHost