Quantity:

More Buying Choices

19 used & new from �6.50

Have one to sell? Sell yours here

Mastering PhpMyAdmin 2.11 for Effective MySQL Management

See larger image

Share your own customer images

Publisher: learn how customers can search inside this book.

Mastering PhpMyAdmin 2.11 for Effective MySQL Management (Paperback)

by Marc Delisle (Author)

4.5 out of 5 stars See all reviews (2 customer reviews)

RRP:	�21.99
Price:	�18.69 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save:	�3.30 (15%)
	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.co.uk. Gift-wrap available.

Want guaranteed delivery by Wednesday, November 11? Choose Express delivery at checkout. See Details

12 new from �15.50 7 used from �6.50

Frequently Bought Together

Customers Who Bought This Item Also Bought

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

by Larry Ullman

4.5 out of 5 stars (56) �14.49

PHP and MySQL Web Development (Developer's Library)

by Luke Welling

3.9 out of 5 stars (39) �15.93

Joomla!: Visual QuickStart Guide (Visual QuickStart Guides)

by Marni Derr

3.8 out of 5 stars (6) �9.47

Search Engine Optimization: An Hour a Day

by Jennifer Grappone

4.4 out of 5 stars (20) �11.99

Get to the Top on Google: Tips and Techniques to Get Your Site to the Top of Google and Stay There

by David Viney

3.9 out of 5 stars (26) �8.74

› Explore similar items

Product details

Paperback: 340 pages
Publisher: Packt Publishing Limited (31 Mar 2008)
Language English
ISBN-10: 1847194184
ISBN-13: 978-1847194183
Product Dimensions: 22.9 x 18.5 x 2 cm

Average Customer Review: 4.5 out of 5 stars See all reviews (2 customer reviews)

Amazon.co.uk Sales Rank: 552,890 in Books (See Bestsellers in Books)
Popular in this category:
#16 in Books > Computing & Internet > Databases > Applications > MySQL > Advanced & Intermediate

Would you like to update product info or give feedback on images?

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

Download Free My SQL GUI opens new browser window

www.Navicat.com/MySQL_GUI - Import/ Export Data, Query, Report and Data Sync, etc Fast & Intuitive

Linux Server Management opens new browser window

www.help4it.co.uk/linux - Proactive UNIX Support Top Quality SLA, 24/7

Database Monitoring Tool opens new browser window

manageengine.adventnet.com - Monitor Database Performance LAMP Apps. Download Now!

Product Description

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.

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.

Suggested Tags from Similar Products

(What's this?)

Be the first one to add a relevant tag (keyword that's strongly related to this product)

php

mysql

database

What Do Customers Ultimately Buy After Viewing This Item?

	95% buy the item featured on this page: Mastering PhpMyAdmin 2.11 for Effective MySQL Management 4.5 out of 5 stars (2) �18.69
	5% buy PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide 4.5 out of 5 stars (56) �14.49

Explore similar items

Customer Reviews

2 Reviews

5 star:		(1)
4 star:		(1)
3 star:		(0)
2 star:		(0)
1 star:		(0)

Average Customer Review

4.5 out of 5 stars (2 customer reviews)

Share your thoughts with other customers:

Create your own review

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

By	Ken Guest (Dublin, Ireland) - See all my reviews (REAL NAME)

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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)

4.0 out of 5 stars authoritive and detailed, 30 April 2008

By	Kae Verens (Monaghan, Ireland) - See all my reviews (REAL NAME)

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? Some screenshots in chapter 15 show examples of this feature.

Marc obviously knows his stuff. As a major contributor to phpMyAdmin since the early days, he is an ideal person to talk us through configuration details and the various tools that phpMyAdmin offers.

There are, however, a number of things which detract from the readability of the book.

This is the first edition for this title, so the following are probably "teething" problems for the author. However, I think they should be taken care of for the second edition, to make the book easier to read. Although, the second edition would most likely have a different title (why is the version number in the title?)

The book is written from a 3rd-person point of view - now we do this, now we do that, our table, our server. This distracted and annoyed me while reading the book.

It is too detailed in places, at the expense of readability. For example, chapter one goes through a blow-by-blow account of how phpMyAdmin came to be, with version numbers and even dates! I feel this should have been left to an appendix. The first chapter of any book should introduce a reader gently to the subject; not pummel the reader with historical facts.

The author sometimes forgets that the reader does not know the subject and its community's habits. As an example, on page 28 the configuration value "PmaAbsoluteUri" is described, but afterwards, I was not sure a) what "Pma" is, or b) what the variable was supposed to do (the book described how it should be configured, but not what it was supposed to do). It isn't until page 33 that the book pointed out that "pma" is an acronym for "phpMyAdmin" used by the community. I don't feel stupid for not getting this immediately, as there is an awkward mixture of letter-cases going on there. By rights, "Pma" should stand for "Phpmyadmin", not "phpMyAdmin".

The sheer number of screenshots was a bit confusing. I feel that screenshots should only be used where the subject is not clear from the text. Two images on every page (almost) has the effect of breaking your concentration when you're trying to read.

The book exclusively deals with how to use phpMyAdmin, but I think there should have been more about how to deal with MySQL itself, using phpMyAdmin. For example, chapter 17 details phpMyAdmin's coverage of character sets and collations. As a person who knows the pain of upgrading a database from MySQL 4 to MySQL 5 while switching character sets, I was looking forward to seeing how this case is handled (which I am sure is pretty common in one form or another). However, the chapter describes the problems with character sets and does not offer any solutions to those problems.

Overall, the book was detailed, and I learned a lot of new stuff from it. I'd recommend it for administrators that are not comfortable with CLI MySQL and want a reference for the best web-based MySQL administration tool out there.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 2 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }