What is phpMyAdmin

m
m
 
Line 1: Line 1:
<seo title="What is phpMyAdmin" metakeywords="mysql database,phpMyAdmin,manage MySQL database" metadescription="What is phpMyAdmin" />
+
<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.
+
<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, edit and add fields as well as manage keys on fields
+
* 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
* Query your databases
+
* 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 your databases
+
* Back up and restore MySQL databases
 +
* Download MySQL dumps
 +
 
 +
To manage MySQL databases, go to your '''cPanel => Databases => phpMyAdmin'''
  
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 are 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.</div>
+
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>

Latest revision as of 13:21, 29 October 2012

rss feed for my website