Knowledgebase

How to Optimize a Database in phpMyAdmin

 

1. Log in to cPanel account.



2. In the Databases section, click on phpMyAdmin.

 

3. Then click on the Expand icon from the navigation tree in the left sidebar.

 

4. As a last step, scroll down and mark Check All then click on the drop-down option and select Optimize tables. The table has been successfully optimized.

 

 

 

 

 

 

 

  • SQL, MySQL, phpmyadmin
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Create a Database in cPanel Account

  1. Log into your cPanel account. 2. In the Databases section, click on MySQL Databases icon.   3. Then, in the New Database field, enter a name for the new database you want to create....

How to Rename a Database in cPanel

  1. Log in your cPanel account.   2. In the Databases field, click on MySQL Databases.   3. Under Current Databases, you can see a list of all your current databases. Locate the Database,...

How to Delete a Database in cPanel

  1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.   3. Under Current Databases feature, you can see a list of all your current databases. Locate the...

How to Create a Database Username in cPanel Account

  1. Log in your cPanel account. 2. In the Databases section, click on MySQL Databases.   3. Then, under MySQL Users, in the Username field, you need to enter the new username you want to...

How to Create a Database Username in cPanel

  1. Log in your cPanel account. 2. In the Databases section, click on MySQL Databases.   3. Under MySQL Users, in the Username field, enter the new username you want to create.   4. Then,...

Powered by WHMCompleteSolution