Mastering phpMyAdmin 2.11 for Effective MySQL Management and over one million other books are available for Amazon Kindle. Learn more
Buy New
$33.24
Qty:1
  • List Price: $34.99
  • Save: $1.75 (5%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Want it Friday, April 18? Order within and choose Two-Day Shipping at checkout. Details
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more

Mastering phpMyAdmin 2.11 for Effective MySQL Management: Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 2.11 Paperback

ISBN-13: 978-1847194183 ISBN-10: 1847194184

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from Collectible from
Kindle
"Please retry"
Paperback
"Please retry"
$33.24
$5.95 $4.06

There is a newer edition of this item:


Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 340 pages
  • Publisher: Packt Publishing (March 18, 2008)
  • Language: English
  • ISBN-10: 1847194184
  • ISBN-13: 978-1847194183
  • Product Dimensions: 9.2 x 7.5 x 0.7 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Best Sellers Rank: #2,555,442 in Books (See Top 100 in Books)

Editorial Reviews

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.

More About the Author

Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin, a web interface for MySQL. He started to contribute to the project in December 1998, when he made the multi-language version. He is involved with phpMyAdmin as a developer, translator and project administrator and enjoys meeting phpMyAdmin users in person.

Marc is a system administrator at Cegep de Sherbrooke, Québec, Canada.

In addition to the "Mastering phpMyAdmin" successive editions, Marc has written "Creating your MySQL Database: Practical Design Tips and "phpMyAdmin Starter", all with Packt Publishing.

Customer Reviews

4.7 out of 5 stars
5 star
4
4 star
2
3 star
0
2 star
0
1 star
0
See all 6 customer reviews
Boy, am I glad I did.
C. Carothers
Next, the author dives into changing data.
Stefan Priebsch
This book served that goal well.
F. A. Goodman

Most Helpful Customer Reviews

3 of 3 people found the following review helpful By Stefan Priebsch on June 30, 2008
Format: Paperback
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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By M. Helmke on January 18, 2009
Format: Paperback
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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
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

Configuration
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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Product Images from Customers

Search
ARRAY(0xa2aaf540)