PhpMyAdmin is a very useful utility for managing your databases directly. You can import and export data, add and drop databases, and modify tables and data types for columns.
Installing PhpMyAdmin
For installation instructions, please click here.
Using PhpMyAdmin
PhpMyAdmin is a great program for managing your databases. It has many great features that allow you to:
- create and drop databases
- create, copy, drop, rename, and alter tables
- backup your data
- import files
- do table maintenance
- run SQL statements
- delete, edit, and add fields
- execute any SQL-statement, even batch-queries
- manage keys on fields
- load text files into tables
- create (*) and read dumps of tables
- export (*) data to CSV, XML and Latex formats
- administer multiple servers
- manage MySQL users and privileges
- check referential integrity
- using Query-by-example (QBE), create complex queries automatically connecting required tables
- create PDF graphics of your Database layout
- search globally in a database or a subset of it
- transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link or ...
- communicate in 42 different languages
- (*) phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps and CSV exports if you use PHP4 >= 4.0.4 with Zlib support (--with-zlib) and/or Bzip2 support (--with-bz2)
You can get to your PhMyAdmin page by clicking on the link in the Installed Applications box under Site Applications>Database in your Site Manager. There is documentation on that page for completing the tasks you want to do. The documentation, in its most current form, for phpMyAdmin is at http://www.phpmyadmin.net/documentation/.