PJR Sales and Service - Knowledgebase - How to optimize a MySQL database using phpMyAdmin?

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98

Home Page

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > How to optimize a MySQL database using phpMyAdmin?

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 perform the optimization, 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.

Add to Favourites
Print this Article

Also Read

How can I import a large database to my account? PhpMyAdmin times out. (Views: 11279)

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10054)

I get syntax error when trying to run a MySQL query. (Views: 1061)

I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)

I have problems accessing my MySQL database remotely (Views: 5298)