Sales & Customer Support: +254748285257

 

How to optimize the database via phpMyAdmin in cPanel?

Home > How to optimize the database via phpMyAdmin in cPanel?
 
Posted by in | Comments

Welcome once again to Hostnali Webhost, a Simple, Secure & Dependable hosting provider. We have optimized hosting plans, Reseller Hosting Plans, Master Reseller plans, VPS servers as well as Dedicated servers. Today, however, we will be focusing on [page_title]. Read on and get the knowledge and skills to make your Web Hosting experience fun.

1. Log into your cPanel account.

2. In the Databases section, open the app installer by clicking on the phpMyAdmin icon.
phpmyadmin icon


3. In left side-bar, Click on the expand button to expand the database like “example”.
phpmyadmin expand db

 

 

 

 

 

4. Under your cPanel username, you can see a list of all databases. Select the appropriate database which you want to optimize.
phpmyadmin db list

5. Scroll down and mark Check All then click on the Drop-down option and select Optimize tables.
optimize db

Table successfully optimized.