{"id":205,"date":"2008-11-26T23:42:20","date_gmt":"2008-11-26T18:12:20","guid":{"rendered":"http:\/\/www.bin-co.com\/blog\/?p=205"},"modified":"2008-11-26T23:42:20","modified_gmt":"2008-11-26T18:12:20","slug":"mastering-phpmyadmin-a-review","status":"publish","type":"post","link":"https:\/\/www.bin-co.com\/blog\/2008\/11\/mastering-phpmyadmin-a-review\/","title":{"rendered":"Mastering phpMyAdmin: A Review"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.bin-co.com\/blog\/wp-content\/uploads\/2008\/11\/phpmyadmin-1-1.png\" alt=\"\" title=\"phpMyAdmin\" width=\"202\" height=\"130\" class=\"alignnone size-full wp-image-206 intro\" align=\"right\" \/><\/p>\n<p class=\"intro\">Some time ago, I was approached by the publisher of the book to write a review of their book &#8216;<a href=\"http:\/\/www.amazon.com\/gp\/product\/1847194184?ie=UTF8&amp;tag=binnva-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=1847194184\">Mastering phpMyAdmin 2.11 for Effective MySQL Management by Marc Delisle<\/a><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.assoc-amazon.com\/e\/ir?t=binnva-20&amp;l=as2&amp;o=1&amp;a=1847194184\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\" \/>[Affiliate link]&#8217;. This got a bit delayed because of the <a href=\"http:\/\/www.bin-co.com\/blog\/2008\/11\/eventr-wordpress-plugin\/\">plugin week<\/a>. But I managed to finish the book today &#8211; so here is the review. Bottom line &#8211; most people are using phpMyAdmin for only the most basic operations(editing data, import, export, etc.). If you are one of them, you don&#8217;t need the book &#8211; you already know all you need to know about phpMyAdmin. But <strong class=\"highlight\">other(like me) use it for advanced purposes &#8211; to manage MySQL, create database\/tables, run queries, etc. I would recommend you get this book. It covers everything from basic usage(which is a bit boring and should be skipped over) to advanced stuff(like designer view, configuration options, triggers, innoDB relation options etc.)<\/strong><\/p>\n<p><iframe src=\"http:\/\/rcm.amazon.com\/e\/cm?t=binnva-20&amp;o=1&amp;p=8&amp;l=as1&amp;asins=1847194184&amp;md=10FE9736YVPPT7A0FBG2&amp;fc1=000000&amp;IS2=1&amp;lt1=_blank&amp;m=amazon&amp;lc1=0000FF&amp;bc1=000000&amp;bg1=FFFFFF&amp;f=ifr\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"><\/iframe><\/p>\n<p>Its an interesting book &#8211; I found it <strong class=\"highlight\">easily readable if you skip over the basic stuff<\/strong>. If you think you already know what a section is talking about, skip over to the next section &#8211; that way, you will not be bored. Because it covers the basics in a fairly comprehensive way(think two screenshots per page(!), most of the things in the book you might already know. But there will be some interesting new tips as well. Some tips I found out by reading the book&#8230;.<\/p>\n<ul>\n<li>In the phpMyAdmin forms(like say, table creation form or row editing form), you can use the Ctrl+Arrow key combination to move the focus around.<\/li>\n<li>If you create a Query bookmark with the same name as a table, that query will be used when you hit the &#8216;Browse&#8217; tab.<\/li>\n<li>If you are using a blob to store images within the database, there is a way to show the image(Browser Transformations, Chapter 16) in the browse view.<\/li>\n<li>And more&#8230;<\/li>\n<\/ul>\n<p>These are the chapters you should definitely read &#8211; some great tips can be found there&#8230;<\/p>\n<ul>\n<li>Chapter 11: Relational System<\/li>\n<li>Chapter 14: Bookmarks<\/li>\n<li>Chapter 16: MIME-Based Transformations<\/li>\n<li>Chapter 18: MySQL 5 Features<\/li>\n<\/ul>\n<h2>Table of Contents<\/h2>\n<p>This should give you an idea of what to expect&#8230;<\/p>\n<ul>\n<li><strong>Preface<\/strong><\/li>\n<li><strong>Chapter 1: Introducing phpMyAdmin<\/strong>\n<ul>\n<li>PHP and MySQL: The Leading Open-Source Duo<\/li>\n<li>What is phpMyAdmin?<\/li>\n<li>History<\/li>\n<li>Awards<\/li>\n<li>phpMyAdmin Features Summary<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 2: Installing phpMyAdmin<\/strong>\n<ul>\n<li>System Requirements<\/li>\n<li>Downloading the Files<\/li>\n<li>Installation<\/li>\n<li>First Connection Configuration<\/li>\n<li>Multi-Server Configuration<\/li>\n<li>Advanced Authentication<\/li>\n<li>Security<\/li>\n<li>Upgrading phpMyAdmin<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 3: Interface Overview<\/strong>\n<ul>\n<li>Panels and Windows<\/li>\n<li>Language Selection<\/li>\n<li>Themes<\/li>\n<li>Left Panel<\/li>\n<li>Right Panel<\/li>\n<li>Query Window<\/li>\n<li>Site-Specific Header and Footer<\/li>\n<li>MySQL Documentation Links<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 4: First Steps<\/strong>\n<ul>\n<li>Database Creation<\/li>\n<li>Creating Our First Table<\/li>\n<li>Manual Data Insertion<\/li>\n<li>Browse Mode<\/li>\n<li>Creating an Additional Table<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 5: Changing Data<\/strong>\n<ul>\n<li>Edit Mode<\/li>\n<li>Multi-Row Editing<\/li>\n<li>Editing the Next Row<\/li>\n<li>Deleting Data<\/li>\n<li>Deleting Tables<\/li>\n<li>Deleting Databases<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 6: Changing Table Structures<\/strong>\n<ul>\n<li>Adding a Field<\/li>\n<li>Editing Field Attributes<\/li>\n<li>TEXT<\/li>\n<li>BLOB (Binary Large Object) Fields<\/li>\n<li>ENUM and SET<\/li>\n<li>DATE, DATETIME, and TIMESTAMP<\/li>\n<li>Bit<\/li>\n<li>Index Management<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 7: Exporting Structure and Data<\/strong>\n<ul>\n<li>Dumps, Backups, and Exports<\/li>\n<li>Database Exports<\/li>\n<li>Table Exports<\/li>\n<li>Selective Exports<\/li>\n<li>Multi-Database Exports<\/li>\n<li>Saving the Export File on the Server<\/li>\n<li>Memory Limits<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 8: Importing Structure and Data<\/strong>\n<ul>\n<li>Limits for the Transfer<\/li>\n<li>Importing SQL Files<\/li>\n<li>Importing CSV Files<\/li>\n<li>Web Server Upload Directories<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 9: Searching Data<\/strong>\n<ul>\n<li>Single-Table Searches<\/li>\n<li>Complete Database Search<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 10: Table and Database Operations<\/strong>\n<ul>\n<li>Table Maintenance<\/li>\n<li>Changing Table Attributes<\/li>\n<li>Renaming, Moving, and Copying Tables<\/li>\n<li>Multi-Table Operations<\/li>\n<li>Database Operations<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 11: The Relational System<\/strong>\n<ul>\n<li>Relational MySQL?<\/li>\n<li>Linked-Tables Infrastructure<\/li>\n<li>Defining Relations with the Relation View<\/li>\n<li>Defining Relations with the Designer<\/li>\n<li>Benefits of the Defined Relations<\/li>\n<li>Column-Commenting<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 12: Entering SQL Commands<\/strong>\n<ul>\n<li>The SQL Query Box<\/li>\n<li>The Query Window<\/li>\n<li>Multi-Statement Queries<\/li>\n<li>Pretty Printing (Syntax-Highlighting)<\/li>\n<li>The SQL Validator<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 13: The Multi-Table Query Generator<\/strong>\n<ul>\n<li>Choosing Tables<\/li>\n<li>Column Criteria<\/li>\n<li>Automatic Joins<\/li>\n<li>Executing the Query<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 14: Bookmarks<\/strong>\n<ul>\n<li>Creating a Bookmark after a Successful Query<\/li>\n<li>Storing a Bookmark before Sending a Query<\/li>\n<li>Multi-Query Bookmarks<\/li>\n<li>Recalling from the Bookmarks List<\/li>\n<li>Public Bookmarks<\/li>\n<li>The Default Initial Query for a Table<\/li>\n<li>Bookmark Parameters<\/li>\n<li>Executing Bookmarks by Browsing the pma_bookmark Table<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 15: System Documentation<\/strong>\n<ul>\n<li>The Database Print View<\/li>\n<li>The Selective Database Print View<\/li>\n<li>The Table Print View<\/li>\n<li>The Data Dictionary<\/li>\n<li>Relational Schema in PDF<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 16: MIME-Based Transformations<\/strong>\n<ul>\n<li>The MIME Column&#8217;s Settings<\/li>\n<li>Requirements for Image Generation<\/li>\n<li>Examples of Transformations<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 17: Character Sets and Collations<\/strong>\n<ul>\n<li>Language Files and UTF-8<\/li>\n<li>Versions of MySQL Prior to 4.1.x<\/li>\n<li>MySQL 4.1.x and Later<\/li>\n<li>Kanji Support<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 18: MySQL 5.0 Features<\/strong>\n<ul>\n<li>Observations on the History of MySQL 5.<\/li>\n<li>Views<\/li>\n<li>Routines: Stored Procedures and Functions<\/li>\n<li>Triggers<\/li>\n<li>Information_schema<\/li>\n<li>Profiling<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 19: MySQL Server Administration<\/strong>\n<ul>\n<li>Entering the Server View<\/li>\n<li>Database Information<\/li>\n<li>Server Operations<\/li>\n<li>Summary<\/li>\n<\/ul>\n<\/li>\n<li><strong>Chapter 20: Troubleshooting and Support<\/strong>\n<ul>\n<li>System Requirements<\/li>\n<li>Base Configuration<\/li>\n<li>Solving Common Errors<\/li>\n<li>Seeking Support<\/li>\n<li>Contributing to the Project<\/li>\n<li>Future phpMyAdmin Versions<\/li>\n<li>Summary<\/li>\n<li>Index<\/li>\n<\/ul>\n<p>A final advice before leaving &#8211; buy the <a href=\"http:\/\/www.wordspy.com\/1996\/09\/dead-tree-editi.html\">dead tree edition<\/a> if possible. The ebook(PDF) has DRM which makes it very hard to read. You have to <strong class=\"highlight\">enter the password every single time you open<\/strong> the file. Its really annoying after a while.<\/p>\n<h2>My Other phpMyAdmin Posts<\/h2>\n<ul>\n<li><a href=\"http:\/\/binnyva.blogspot.com\/2006\/08\/installing-phpmyadmin-28.html\">Installing phpMyAdmin 2.8<\/a><\/li>\n<li><a href=\"http:\/\/binnyva.blogspot.com\/2006\/08\/phpmyadmin-tips-and-tricks-database.html\">phpMyAdmin Tips and Tricks &#8211; Database Backup and Restore<\/a><\/li>\n<li><a href=\"http:\/\/binnyva.blogspot.com\/2006\/08\/installing-and-configuring-phpmyadmin.html\">Installing and Configuring phpMyAdmin<\/a><\/li>\n<li><a href=\"http:\/\/binnyva.blogspot.com\/2006\/08\/managing-databases-with-mysql-clients.html\">Managing Databases with MySQL Clients &#8211; phpMyAdmin<\/a><\/li>\n<\/ul>\n<h2>Related Links<\/h2>\n<ul>\n<li><a href=\"http:\/\/www.packtpub.com\/files\/Mastering-phpMyAdmin-2-11-for-Effective-MySQL-Management-Sample-Chapter-Chapter-Table-and-Database-Operations.pdf\">Sample Chapter: Table and Database Operations<\/a><\/li>\n<li><a href=\"http:\/\/www.packtpub.com\/phpmyadmin-3rd-edition\/book\">Mastering phpMyAdmin Book Details<\/a><\/li>\n<li><a href=\"http:\/\/verens.com\/archives\/2008\/04\/26\/review-mastering-phpmyadmin-211-for-effective-mysql-management\/\">review: Mastering phpMyAdmin 2.11 for Effective MySQL Management<\/a><\/li>\n<li><a href=\"http:\/\/blogs.linux.ie\/kenguest\/2008\/05\/12\/book-review-mastering-phpmyadmin-211-for-effective-mysql-management-by-marc-delisle\/\">Book review: \u201cMastering phpMyAdmin 2.11 for Effective MySQL Management\u201d by Marc Delisle<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Some time ago, I was approched by the publisher of the book to write a review of their book &#8216;<a href=\"http:\/\/www.amazon.com\/gp\/product\/1847194184?ie=UTF8&amp;tag=binnva-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=1847194184\">Mastering phpMyAdmin 2.11 for Effective MySQL Management by Marc Delisle<\/a><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.assoc-amazon.com\/e\/ir?t=binnva-20&amp;l=as2&amp;o=1&amp;a=1847194184\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\" \/>[Affliate link]&#8217;. This got a bit delayed because of the <a href=\"http:\/\/www.bin-co.com\/blog\/2008\/11\/eventr-wordpress-plugin\/\">plugin week<\/a>. But I managed to finish the book today &#8211; so here is the review. Bottom line &#8211; most people are using phpMyAdmin for only the most basic operations(editing data, import, export, etc.). If you are one of them, you don&#8217;t need the book &#8211; you already know all you need to know about phpMyAdmin. But <strong class=\"highlight\">other(like me) use it for advanced purposes &#8211; to manage MySQL, create database\/tables, run queries, etc. I would recommend you get this book. It covers everything from basic usage(which is a bit boring and should be skipped over) to advanced stuff(like designer view, configuration options, triggers, innoDB relation options etc.)<\/strong><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,17,22,30],"tags":[66,211,239],"class_list":["post-205","post","type-post","status-publish","format-standard","hentry","category-database","category-mysql","category-review","category-web-development","tag-book","tag-phpmyadmin","tag-review"],"_links":{"self":[{"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/posts\/205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/comments?post=205"}],"version-history":[{"count":0,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/posts\/205\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/media?parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/categories?post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/tags?post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}