Packt Publishing’s invitation to review “Mastering phpMyAdmin 2.11 for Effective MySQL Management” was admittedly met with a bit of skepticism. Although I’m certainly grateful they think highly enough of my opinion to warrant an invitation, I wondered whether a book on this particular topic was even merited. Having used phpMyAdmin for the past 10 years, largely because it’s so incredibly user friendly, it struck me as a bit odd somebody would even need an introductory book in order to effectively use the software. However, after spending a few weeks with the book, I’m pleased to report my skepticism was unfounded, and in fact it even taught this old dog a few new tricks along the way!
Ringing in at just 318 pages, this book bucks the trend of attempting to cover every topic under the sun, wasting no time with unnecessary introductions to the concept of open source and lengthy historical perspective. Instead, the author (Marc Delisle) jumps almost directly into coverage of the installation and configuration process, along the way detailing security-specific steps you might consider in order to protect data and limit access.
Chapters 3 through 6 cover what you might expect, showing you how to create databases, populate tables with data, and query the tables. Although the beauty of phpMyAdmin is that understanding how to complete such tasks is obvious even to newcomers, within these chapters you will find several very useful tips and tricks, such as how to tweak the configuration for more effective data input and browsing, creating indexes, and optimizing tables.
Chapters 7 through 17 are in my opinion the most valuable of the book, as they introduce phpMyAdmin features you’re likely not going to immediately grasp or even know exist. Among many topics, you’ll learn how to effectively import and export data, use the table designer, and create bookmarks which allow you to easily execute commonly used queries. I learned quite a bit about phpMyAdmin within these chapters, for instance I had no idea you could export SQL data to YAML and even LaTeX, and now use the bookmark feature more effectively than ever before.
Chapter 18 introduces phpMyAdmin features specifically tied to MySQL 5.0. In this chapter you’ll learn how to create and manage views, stored procedures, and triggers. Finally, chapters 19 and 20 present short introductions to MySQL administration using the phpMyAdmin interface, and to troubleshooting, respectively.
Perhaps my only gripe is one of an editorial nature. Although phpMyAdmin is by now a rather mature project, development does continue, with version 3.0 having been released in September, 2008. The decision to include in the title the version of phpMyAdmin available at the time of the book’s publication (2.11) strikes me as very odd, in particular because it could lead some prospective readers to believe the book is no longer relevant given the current release number of 3.1.0. I raise this point because on the contrary this book is still quite relevant today, and still worth picking up whether you’re a newcomer to the project or a seasoned user such as myself.
In closing, if you’re tasked with managing a MySQL database and have chosen phpMyAdmin as your management solution, “Mastering phpMyAdmin 2.11 for Effective MySQL Management” is clearly a valuable addition to your technical library. Head on over to Amazon.com to purchase a copy today! Or click here to learn more about the book via the Packt Publishing website.