How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel.

  • To optimize, log in to your phpMyAdmin and select the database whose tables you wish to optimize.
  • A list with all the database's tables will appear. Tick the tables you wish to optimize, or simply click [Check All] to select all tables.
  • From the [With selected:] drop-down menu choose Optimize table. This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.
  • 0 أعضاء وجدوا هذه المقالة مفيدة
هل كانت المقالة مفيدة ؟

مقالات مشابهة

What is the default mysql port?

3306 is the default mysql port.

How to connect to PostgreSQL from PHP?

For connecting to a PostgreSQL database from PHP you can use the standard pg_Connect() function.

How to import an .sql file into a Postgre database?

Log in to your cPanel and open the phpPgAdmin tool. Then click on the PostgreSQL link at the left...

How to create a Postgre user?

In order to create a PostgreSQL user you should go to your cPanel -> PostgreSQL Databases...

How to create a Postgre database?

Creating a PostgreSQL database is a straight-forward process. All you need to do is log in to...