m |
m |
||
| Line 15: | Line 15: | ||
* Download MySQL dumps | * Download MySQL dumps | ||
| − | To manage MySQL databases, go to your cPanel => | + | To manage MySQL databases, go to your '''cPanel => Databases => phpMyAdmin''' |
| + | |||
You will see the list of your databases from the left side. Simply choose the database needed and perform the operation needed. | You will see the list of your databases from the left side. Simply choose the database needed and perform the operation needed. | ||
Let's take an example of how to manage the MySQL database (''user_db'') and optimize its tables. | Let's take an example of how to manage the MySQL database (''user_db'') and optimize its tables. | ||
| − | Once you get to the phpMyAdmin screen choose user_db database from the left. You should get its tables listed now. Select the tables you would like to optimize by checking the box next to the desired tables and select '''Optimize table''' from the drop-down menu at the bottom of the page. | + | Once you get to the phpMyAdmin screen choose user_db database from the left. You should get its tables listed now. |
| + | |||
| + | {{#icon: phpMyAdmin.png|phpMyAdmin}} | ||
| + | |||
| + | Select the tables you would like to optimize by checking the box next to the desired tables and select '''Optimize table''' from the drop-down menu at the bottom of the page. | ||
| + | |||
| + | {{#icon: manage MySQL database.png|phpMyAdmin}} | ||
| + | |||
| + | {{#icon: phpMyAdmin tool.png|phpMyAdmin}} | ||
If you want to restore a MySQL dump for a database from a different server, then you need to download a MySQL dump from the old server, create a database needed and import the MySQL dump.</div> | If you want to restore a MySQL dump for a database from a different server, then you need to download a MySQL dump from the old server, create a database needed and import the MySQL dump.</div> | ||
.jpg)
