Mastering phpMyAdmin 2.11 for Effective MySQL Management and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Mastering phpMyAdmin 2.11 for Effective MySQL Management on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Mastering Phpmyadmin 2.11 for Effective MySQL Management [Paperback]

Marc Delisle
4.5 out of 5 stars  See all reviews (2 customer reviews)
Price: 21.99 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Monday, 1 Sept.? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 14.41  
Paperback 21.99  
There is a newer edition of this item:
Mastering phpMyAdmin 3.1 for Effective MySQL Management Mastering phpMyAdmin 3.1 for Effective MySQL Management 4.0 out of 5 stars (3)
In stock.

Book Description

31 Mar 2008
This book is an upgrade from the previous version that covered phpMyAdmin Version 2.8. Version 2.10 introduced a new GUI for relations, called Designer, and version 2.11 adds support for creating Views from query results, manages triggers, procedures and functions and has an improved interface for servers handling large number of databases/tables. Whether you are an experienced developer, system administrator, web designer or new to MySQL, phpMyAdmin is a must-have tool for anyone who needs to manage MySQL databases and tables. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.

Product details

  • Paperback: 340 pages
  • Publisher: Packt Publishing (31 Mar 2008)
  • Language: English
  • ISBN-10: 1847194184
  • ISBN-13: 978-1847194183
  • Product Dimensions: 1.8 x 18.8 x 23.1 cm
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 1,549,439 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

Marc Delisle is a member of the MySQL Developers Guild - which regroups community developers - because of his involvement with phpMyAdmin. He started to contribute to this popular MySQL web interface in December 1998, when he made the first multi-language version. He has been actively involved with the phpMyAdmin project since May 2001 as a developer and project administrator. He has worked since 1980 at Coll¿ge de Sherbrooke, Qu¿bec, Canada, as an application programmer and network manager. He has also been teaching networking, security, Linux servers, and PHP/MySQL application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

3 star
2 star
1 star
4.5 out of 5 stars
4.5 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars Very Comprehensive, highly recommended 13 May 2008
This book on phpMyAdmin is written by one of the core developers of the application; one which I think just about any software developer utilising MySQL has dabbled with at the least. I can honestly say that anyone that experimented with phpMyAdmin before reading this book will use it much more thoroughly and more productively afterwards.

This is a well written, easily read, book that is fully comprehensive regarding how to use phpMyAdmin for both casually inserting and maintaining data in a mysql database; checking queries before utilising them in your code; data transformations; and actual database and user administration, such as changing the structure of your databases, collations, creating system documentation, assigning privileges and more.

I scarcely believe this book could be much more detailed, especially as it often has more than two screen shots per page - it is no wonder that I now know much more of what phpMyAdmin is capable of!

The troubleshooting chapter at the back seems invaluable and the chapter covering MySQL 5 additions seems a useful refresher for those of us that may need to be reminded of new functionality present only in that more recent version of MySQL, and after reading this book I fully expect that I shall be using phpmyadmin more and not using either the MySQL Query Browser or Oracle's SQL Developer as much.

The blurb on the back of the book says that it is for every serious phpMyAdmin user who would like to use this outstanding application to its full power - after reading it I am very much inclined to agree and would recommend it to anyone that uses phpMyAdmin on a daily basis.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars authoritive and detailed 30 April 2008
In short, my review is this: overall, the book detailed everything I can think of (and more) about phpMyAdmin - I learned about some features in phpMyAdmin that I was not already aware of. I would ask for less screenshots, more how-tos and less 3rd-person speech for the next revision, but if there are any questions I have about phpMyAdmin, the answers are in this book.

I use phpMyAdmin only occasionally, when I can't get direct access to the database in question (I'm a console jockey - there's nothing like the thrill of tappity-tapping away, knowing that you're doing Important Stuff and ...well, yeah - geek).

I've used phpMyAdmin since forever, so was familiar with its common uses - importing/exporting databases, running simple queries, etc. I was interested to see if there was anything that I might have missed. And who better to show me than one of the developers, Marc Delisle.

The table of contents was large, spread over 12 pages. I feel it would have been easier to read if there was one page detailing just h1 listings, followed by 2-3 pages of h2 listings. The h3 and h4 listings could have been shown at the beginning of the concerned chapters.

Disregarding that, scanning the contents showed some features that I was not aware of. Did you know that phpMyAdmin has a built-in relations manager? Even if the engine used is MyISAM, which does not manage referential integrity, phpMyAdmin will protect you and manage it for you if queries are run through it.

Screenshots are provided for everything. This makes some things much easier to understand. Sometimes it made interesting features stand out even more. Did you know that phpMyAdmin can generate PDFs of the relational schema of a database?
Read more ›
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.7 out of 5 stars  6 reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars Well done, Marc! 30 Jun 2008
By Stefan Priebsch - Published on
Marc starts off by explaining how to install and configure phpMyAdmin on Windows and Linux. Given a working LAMP or WAMP platform, any reader with basic PHP skills should be able to get phpMyAdmin up and running really quickly.

After a first overview over the user interface, the author explains how to create databases and tables, and how to enter data. A quick overview over phpMyAdmin's querying capabilities concludes the "First steps" chapter. Next, the author dives into changing data. I was surprised to learn that phpMyAdmin has a multi-row editing feature.

The "Changing Table Structures" chapter deals with how to edit table definitions and the various column types like TEXT, BLOB ENUM, and DATE. This chapter also deals with index management, and explaining queries.

Chapter 7, "Exporting Structure and Data", deals with exporting databases. Though I personally have never seen the value of exporting a database to anything else than SQL, I was rather surprised to learn that phpMyAdmin supports exporting to PDF, Word, Excep, Open Office, Latex, XML, or YAML format.

Consequently, the next chapter deals with importing structure and data. Due to various server limits like timeout, or limitations of the file upload size, this is not always as easy as it might seem. The author explains the problems and shows ways to circumvent restrictions, which I think is very important, as I see quite a few users in the field struggling with importing large database dump files.

Chapter 9 deals with searching the database, without having to write SQL statements. I was not aware, for example, of the possiblity to search all database tables for strings or even regular expressions. The next chapter covers table and database operations, including table maintenance, renaming tables, moving and copying tables, appending data to a table, and even copying a whole database, which can be an interesting alternative to creating a backup before upgrading it. The database backup feature is complemented by the possibility to rename a database, thus allowing you to create a backup and potentially restore it without having do download and upload SQL dumps.

Chapter 11 introduces the relational system. Since MyISAM tables do not support key relationships, phpMyAdmin can optionally administer information about table relations. The author explains how to set up phpMyAdmin to do this, and continues by introducing the Designer, which is an ajaxy tool to work with table relationships, foreign keys, and check the referential integrity of a database.

Of course, a chapter on how to write SQL statements with phpMyAdmin can not be left out from a book like this. The author explains how phpMyAdmin helps the user to write SQL statements, and shows how an external SQL validator can be used, to make sure that the statements conform to the SQL standard. He then dives into creating multi-table queries, which is where more complex criteria and joins come into play.

Next, the author explains bookmarks, a way of storing statements for later reuse, just like browser bookmarks. In that chapter, I was surprised to learn that phpMyAdmin even allows changing the default initial query that is executed when the table is browsed.

Following a short chapter on how to create database documentation in tabular or PDF format, mime-based transformations are explained. Mime-based transformations allow you, for example, to configure phpMyAdmin to display thumbnails of images stored in the database, format dates, create links, or display strings in hex format, which can be useful to debug issues with different or wrong character encodings. These transformations were, admittedly, completely new for me, and I think they may in fact be one of the most powerful features phpMyAdmin has.

Towards the end of the book, the author covers an important topic, namely character sets and collations. He explains the differences between MySQL versions before and after 4.1, and then continues with a short introduction of new features in MySQL 5, like views, stored procedures, triggers, information_schema as the standards-compatible way to access meta data, and profiling.

This chapter is followed by "MySQL Server Administration", which comprises of user and privilege management, retrieving database information, and checking the server status. The book is concluded with a Troubleshooting chapter that gives hints on how to solve common errors.

I like the book for its straight and logical structure. The author's explanations are short and to the point, so the user is provided with the right amount of information to get going with phpMyAdmin. I would strongly suggest to have a basic level understanding of database theory (tables, relations, keys), as the author does not give any theoretical background, but just shows how to make use of the features in phpMyAdmin.

For $34.99, you get 300+ pages packed with information about all aspects of phpMyAdmin. I must say that the book's layout is not one of the most beautiful ones I have ever seen, and some screen shots could be of better quality, but this does not really affect the reading experience too much. I can definitely recommend this book, and according to the phpMyAdmin website, it is also available in various translations like Czech, German, Italian, and Spanish.
1 of 1 people found the following review helpful
5.0 out of 5 stars I didn't realize phpMyAdmin could do so much -- thanks for the informative book! 19 Jan 2009
By M. Helmke - Published on
I am the sole person responsible for seven websites that use MySQL databases, and have worked on the back end of several others. Over the years I have worked on these databases in many different ways. I've done it from the command line, via ssh. I've done it using PHP scripts within the software being run on a site. I have also used phpMyAdmin. Each method has applications and moments where I would prefer using it to the others at my disposal.

I have generally used phpMyAdmin only in those moments when I had something quick and simple to do, or when a hosting company did not provide ssh or command line access. This was mainly because I did not realize how powerful and flexible the software can be.

I didn't realize how amazingly easy it is to configure this program, and how much you can do with phpMyAdmin. The book starts with the basic foundation of installation and initial configuration, then walks you through the steps of using it in your unique setting. The author makes a note of default settings as well as some that are likely preset to other options by web hosting providers. It clearly outlines how to change those defaults if you are using the software on a server you own or control.

Mastering phpMyAdmin is clearly written, using easy to comprehend examples, with a chapter structure that begins without the need for previous knowledge and takes you to uses and procedures that are far beyond the needs of most of us. That's cool! It is always my preference to have more information at my disposal than I am likely to need, rather than the other way around. With this book, I can't imagine needing to look up any other documentation source to figure out how to create, manipulate, check, repair, backup, restore, optimize, or otherwise interact with a MySQL database.

It is my opinion that this book would be very helpful to people who are completely new to database and website administration, who perhaps already have access to phpMyAdmin through their web hosting provider through cPanel or Plesk, or have the permissions on the server to install it themselves. As an intermediate (definitely not guru-level) admin, I found the book a helpful and enjoyable way to discover new uses for the software as well as new ways to configure it to remove limitations I had previously encountered, such as only being able to import sql files smaller than 2 Mb. If that sounds interesting, take a look at the book info on the publisher's website or persue a copy at your local bookstore.
4.0 out of 5 stars phpMyAdmin in the Real World 28 May 2009
By Blane Warrene - Published on
Mastering phpMyAdmin 2.11 for Effective MySQL Management: Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 2.11

This is both a timely and largely timeless book for web developers and administrators who work with MySQL and PHP. While the software will change from time to time on a normal release schedule - the baseline functionality will remain intact.

Marc Delisle did a fine job of balancing his analysis and content for both beginners as well as more seasoned veterans to database administration. The book encompasses installation, setup, getting started and standard functions as well as more advanced capabilities of phpMyAdmin.

There are really four key areas where, from my own experience as an analyst and web administrator, the majority of issues and questions surface when using MySQL.

1) Configuration
2) Administering users and permissions
3) Maintaining and equally as important backing up and restoring databases or tables
4) Advanced techniques (using SQL and querying) and reporting

Mr. Delisle handled the configuration of the system well, clearly illustrating how most users will use phpMyAdmin on a single server. I was relieved to see his coverage of multi-server setup and attention paid to secure methods of authentication in this multi-server mode.

I felt this was clearly defined and easy to replicate when testing the "how-to" approach to this topic. This allows administrators a simple way to handle multiple databases on multiple servers if they are servicing clients who require dedicated installations for their data.

Users and Permissions
This was one of my own biggest stumbling blocks when I started using MySQL and there were not many easy to use tools to simplify these administering efforts. phpMyAdmin deftly handles this core function of managing MySQL. This is covered in detail in Chapter 19.

Database and Table Maintenance
One of the challenges of the web world is that most administrators charged with overseeing the web presence of smaller business or hobbyists are not by trade database administrators. phpMyAdmin enables a novice administrator to tackle some of the key tasks - such as indexing larger tables to improve performance, importing tables via SQL, exporting data and even backing up and restoring.

There is an entire community committed to just educating on database tuning and maintenance and phpMyAdmin provides the tools for doing so as the administrator develops this knowledge base.

Advanced Techniques
One of the benefits of a good how-to guide is that is graduates progressively from getting started to an appendix of advanced techniques. As users build confidence with phpMyAdmin they can take advantage of the guidance in this book on tasks requiring multi-table queries, creating views, triggers or stored procedures (specific to MySQL 5.x).

Overall, this title provides comprehensive coverage of phpMyAdmin due to Mr. Delisle's long career in maintaining and developing with MySQL.
5.0 out of 5 stars A Necessity You Shouldn't Pass Up 13 Feb 2009
By C. Carothers - Published on
Format:Paperback|Verified Purchase
I had no experience with PHP. I had no experience with MySQL. phpMyAdmin was free, but it all looked Greek to me. I took a chance on this book.

Boy, am I glad I did. It explained very nicely everything I needed to know about this utility tool. I'd have been lost without it. I can't imagine anyone using phpMyAdmin without this book.

And phpMyAdmin is a necessary tool, also. I'm in it quite a bit every day. I built my database using it. I entered my test data using it. I built my PHP scripts using it. I debugged my scripts using it. And phpMyAdmin is free. All you have to do is buy this book.
5.0 out of 5 stars Excellent book - great addition to your MySQL library 31 Dec 2008
By W. Jason Gilmore - Published on
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 (not to mention authored a book or two (Beginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional) along the way), 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.

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.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category