Special offer
.com Domain Name
English
+370 5 205 5502 sales@monovm.com

Databases have the potential to grow very large, particularly on sites that receive a lot of traffic or have a large amount of content. In such cases, periodic database optimization may help improve web site performance.

17

Mar, 19

Optimize WordPress from phpmyadmin

Optimizing Mysql Databases

Databases have the potential to grow very large, particularly on sites that receive a lot of traffic or have a large amount of content. In such cases, periodic database optimization may help improve web site performance.

To optimize a MySQL database, follow these steps:

Log in to cPanel server.

In the Databases section of the cPanel home screen, click phpMyAdmin. The phpMyAdmin administration page appears in a new window.

In the left pane, click the name of the database that you want to optimize. For example, the following image shows the example_wordpress database selected

Optimize WordPress from phpmyadmin

In the right panel, select the check boxes for the tables in the database that you want to optimize.

Optimize WordPress from phpmyadmin

Optimize WordPress from phpmyadmin

In the 'With selected' list box, select 'Optimize table'. phpMyAdmin informs you whether or not the optimization process is successful.

Repairing Mysql Databases

Databases can become corrupted for many number of reasons, from software defects to hardware issues. If this occurs, you can try to repair database tables using phpMyAdmin.

To repair MySQL database tables, follow these steps:

Log in to cPanel.

In the Databases section of the cPanel home screen, click phpMyAdmin. The phpMyAdmin administration page appears in a new window.

In the left pane, click the name of the database that you want to work on. For example, the following image shows the example_wordpress database selected:

db4

On the right side, select the check boxes for the tables in the database that you want to repair.

In the 'With selected' list box, select 'Repair table'. phpMyAdmin informs you whether or not the repair process is successful.

db0

linda Y

My name is Linda, I have Master degree in Information Technology Engineering. I have some experiences in working with Windows and Linux VPS and I have been working for 2 years on Virtualization and Hosting.