Site Moved

This site has been moved to a new location - Bin-Blog. All new post will appear at the new location.


Managing Databases with MySQL Clients - phpMyAdmin

There are many MySQL Clients(or database administration tools) out there - MySQL Front End, Tora, mysql etc. But in the web environment, one client rules - phpMyAdmin. phpMyAdmin is a PHP based(obviously) GUI administration tool for MySQL.

When I began programming in Linux, I could not use the DB Administration tool my co-workers were using. They were using MySQL Front End - and only the windows version was available for it. Since no one in my office used Linux, none knew another DBA for Linux. One suggested Tora, but I could not get it to run - some dependencies were missing. Anyway, I was forced to use mysql - yes, the command line client that came with MySQL Server. You can start it by bringing up a terminal and entering 'mysql' into it. Then you type every SQL command you want to execute into it. Trust me, it was not fun. The biggest problems was that I want to copy something and press 'Ctrl+C' - in the terminal 'Ctrl+C' is not Copy - its Close. So the client goes down. It was very irritating. Anyway I found phpMyAdmin before long and have been using it ever since(even after I got Tora running).

The biggest advantages of phpMyAdmin is that it is web based - it runs on any server capable of handling PHP. Because of this all the online Database Administration is done using phpMyAdmin. If you have a site of your own, and you have the control panel access to it, you will know what I mean. They database management part will be handled by phpMyAdmin. The phpMyAdmin site cites the following as the features of phpMyAdmin...

  • Browse, view and drop databases, tables, views, fields and indexes.
  • Create, copy, drop, rename and alter databases, tables, fields and indexes.
  • Maintenance server, databases and tables, with proposals on server configuration.
  • Execute, edit and bookmark any SQL-statement, even batch-queries.
  • Create and read dumps of tables - in various formats like CSV, SQL, etc.
  • Export data to various formats: CSV, SQL, XML, Excel and more.
  • Administer multiple servers.
  • Manage MySQL users and privileges.
  • Check referential integrity in MyISAM tables.
  • Using Query-by-example (QBE), create complex queries automatically connecting required tables.
  • Search globally in a database or a subset of it.
  • Support InnoDB tables and foreign keys.
  • Support mysqli, the improved MySQL extension.
  • And more...

phpMyAdmin is so commonly used that there is a book - Mastering phpMyAdmin for effective MySQL Management - that aims to teach it.


1 Comment:

Anonymous said...

hi all, i was amazed after knowing that sqlyog is an amazing db administartion tool.I must tell you this guys have awesome powertools with cool & amazing features.