m |
m |
||
| Line 1: | Line 1: | ||
| − | <div align=justify> | + | <seo title="What is phpMyAdmin" metakeywords="mysql database,phpMyAdmin,manage MySQL database,edit MySQL,download mysql,restore mysql,create database" metadescription="What is phpMyAdmin" /> |
| + | |||
| + | <div align=justify>'''phpMyAdmin''' is a tool written in PHP intended to administrate and manage MySQL databases through a graphic user interface over the Web. phpMyAdmin has become one of the most popular web-based MySQL management tools as it comes with detailed documentation and is being supported by a large multi-language community. MyIdealHost [http://myidealhost.com/about.shtml web hosting provider] offers phpMyAdmin as a default MySQL management application. | ||
phpMyAdmin tool allows you to perform a wide range of operations with MySQL: | phpMyAdmin tool allows you to perform a wide range of operations with MySQL: | ||
| − | * Create, drop and edit tables | + | * Create databases |
| − | * Delete, | + | * Create, drop and edit MySQL tables |
| + | * Delete, add and edit MySQL fields as well as manage keys on fields | ||
* Execute SQL statements | * Execute SQL statements | ||
| − | * | + | * Repair and optimize MySQL tables |
* Manage user privileges | * Manage user privileges | ||
* Export data into various formats (CSV, SQL, XML, Excel and other popular formats) | * Export data into various formats (CSV, SQL, XML, Excel and other popular formats) | ||
| − | * Back up and restore | + | * Back up and restore MySQL databases |
| + | * Download MySQL dumps | ||
| + | |||
| + | 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 | + | 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. | ||
| + | See more [http://myidealhost.com/tutorials/How_to_import_a_database here].</div> | ||
.jpg)
