How to Use phpMyAdmin To Optimize a Database?

 

You can log into phpMyAdmin from your cPanel.  From there:

1) Click on the table icon next to the database name you are working on

2) On the right hand column your tables should be listed. Scroll down till you see the “Check all” link.

3) Click on that link, make sure all database tables are checked and then from the dropdown next to it, select “Optimize table”.

This command will not work on all table types.

Was this answer helpful?

 Print this Article

Also Read

How to Optimize Wordpress?

Wordpress is one of the most popular blogging platforms available, and is used widely for...

Guide for optimizing your site for the purpose of using less system resources

This section can be used as a guide for optimizing your site for the purpose of using less system...

How do I connect to my server via SSH?

Yes, we offer SSH (secure shell) access.We offer you jailed SSH, which limits access to your...

How to Register Private Nameservers?

Why register nameservers? New nameservers need to be registered with your registrar before they...