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.

Comments are closed.

Basic Helpful Tutorials (41)
Cpanel (13)
Domain name (39)
Email (53)
FTP (9)
General FAQ (60)
Home Page (14)
Mysql (7)
Our Reseller Program Tutorials (4)
Pre Sales (25)
Reseller Hosting (5)
Script installations (7)
SSL (22)
TBR (8)
Video Tutorials (7)
Website Builders (28)
Windows Hosting (14)

WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

Sibername.com is an
ICANN Accredited Registrar

ICANN Certified Registrar
Sibername.com is an Authority (CIRA)
certified .CA Domain Name Registrar
Sibername.com is an Authority (CIRA) certified .CA Domain Name Registrar
Click for the BBB Business Review of this Internet Services in Ottawa ON


HACKER SAFE certified sites prevent over 99.9% of hacker crime.
  • Facebook
  • Twitter