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

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading Mastering phpMyAdmin 3.1 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 3.1 for Effective MySQL Management [Paperback]

Marc Delisle

Price: CDN$ 39.10 & FREE Shipping. 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
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Tuesday, October 28? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Kindle Edition CDN $12.59  
Paperback CDN $39.10  
Join Amazon Student in Canada


Book Description

March 1 2009

Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1

  • Covers version 3.1, the latest version of phpMyAdmin
  • Administer your MySQL databases with phpMyAdmin
  • Manage users and privileges with MySQL Server Administration tools
  • Get to grips with the hidden features and capabilities of phpMyAdmin

In Detail

MySQL has gained wide popularity because of its open-source nature, performance, reliability, robustness, and support for various platforms.

phpMyAdmin is a web-based front-end to manage MySQL databases and has been adopted by a number of open-source distributors. It is one of the most widely used open-source applications written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 52 languages. The powerful graphical interface of version 3.1 has made phpMyAdmin an indispensable tool for MySQL and web developers.

This is the first book that covers version 3.1, the latest version of phpMyAdmin. It has been fully updated from the previous version that covered phpMyAdmin Version 2.11. It is a comprehensive guide to unlocking the full potential of phpMyAdmin. It builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet right from showing you how to set up and manage the database with clear, step-by-step instructions and screenshots to exploring the less well known and generally under-used features and capabilities of phpMyAdmin in depth. Along the way you'll build a more detailed understanding of SQL and how it works in MySQL.

Whether you are an experienced developer, system administrator, web designer or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your MySQL.

What you will learn from this book?

  • Administer MySQL users and get statistics about MySQL servers and databases
  • Create better database tables and relational structures
  • Generate multiple SQL queries and build a more detailed understanding of SQL and its workings
  • Prepare better documentation of evolving table structures
  • Manage databases, table data and structures, and indexes to create efficient databases
  • Learn the different mechanisms involved in importing SQL and CSV files
  • Examine the modified behavior of phpMyAdmin to use the outstanding application to its full power
  • Perform day-to-day database and table management effectively with the new interface to ease your work

Approach

The book is a step-by-step tutorial for phpMyAdmin explaining and demonstrating the potential of this tool with clear instructions and screenshots. After covering installation and basic features of phpMyAdmin it goes on to show its less well known and generally under-used features and capabilities.

Who this book is written for?

phpMyAdmin is a must-have tool for everyone who needs to manage their MySQL databases and tables in an effective manner. 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: 352 pages
  • Publisher: Packt Publishing; 4th edition edition (March 1 2009)
  • Language: English
  • ISBN-10: 1847197868
  • ISBN-13: 978-1847197863
  • Product Dimensions: 23.5 x 19 x 1.9 cm
  • Shipping Weight: 721 g
  • Amazon Bestsellers Rank: #1,449,962 in Books (See Top 100 in Books)

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

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.4 out of 5 stars  5 reviews
2 of 2 people found the following review helpful
4.0 out of 5 stars Mastering phpMyAdmin 3.1 July 9 2009
By Sebastian Nohn - Published on Amazon.com
Format:Paperback
I've been using phpMyAdmin since... Hmmm... Well... The times before I used to code in PHP. So when offered to review Mastering phpMyAdmin 3.1 by Marc Deslisle, I didn't expected to learn anything new, but I was bwrong.

The book is full of information for all kinds of users from beginner to professional. I only gallopped through the first chapters covering setup, basic usage etc. while luckily not covering basic SQL topics, so if you are new to phpMyAdmin and know basic SQL, this book may be the right one for you. Since phpMyAdmin has evolved in the last years and is still evolving, also the experienced user may find something new here.

About one third of the 326 pages cover advanced topics like the SQL validator, advanced bookmarking or the database documentation generator Although I've been using phpMyAdmin for years now, some of the covered topics were new to me.

If you are new to phpMyAdmin, you should buy this book. Even if you are using phpMyAdmin since some years, you may find Mastering phpMyAdmin useful.
1 of 1 people found the following review helpful
5.0 out of 5 stars I read a great review for this book Oct. 15 2009
By Daniel Aranzamendi - Published on Amazon.com
Format:Paperback|Verified Purchase
I will paste a review of Ben Dodson (one of the books reviewers) hoping it helps other users. I just bought the book and I hope it's as good as this review says:

"I was recently asked by Packt Publishing to review a copy of their latest book, Mastering phpMyAdmin 3.1 which promises to "increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1'. I was a little skeptical at first of a book on phpMyAdmin, the most widely used MySQL admin tool, especially when it arrived at 325 pages! However, there is a huge amount of information that really is very useful to every PHP developer out there whether you are a beginner or an advanced user.

Now, most people I've mentioned the book to have scoffed and said something along the lines of "I already know how to use phpMyAdmin". Like them, I thought I knew what phpMyAdmin was and what it could do but it turns out there are huge amounts of functionality I never knew existed in MySQL let alone in phpMyAdmin!
For the Beginner

The book starts off with a very gradual introduction to phpMyAdmin covering everything from basic installation and setup to a detailed explanation of the overall interface. I was particularly pleased to see an in-depth chapter on security configuration at the beginning of the book which would help any newcomer make sure that their setup is completely secure - usually such chapters are found at the back in the appendices! The first six chapters follow in a similar vein with very basic information about how to run SQL queries, edit data, change structures, and so on but chapters seven and eight deal with exporting and importing data which is one of the many areas that I have seen developers struggle with in the past. There is a good explanation of the different methods for importing / exporting including the benefits of certain types over others. Crucially, there is a section on CSV using LOAD DATA which is something that has always seemed to lack proper explanation to me in the past.

There then follows a few more chapters which more advanced users can probably skip such as searching, an overview of relational databases, and table / database operations.
Advanced Topics

I would say that the real meat of the book for experienced PHP developers begins at chapter thirteen with each further chapter adding useful knowledge. I've listed the key highlights of these chapters below:

* The Multi-Table Query Generator - A powerful tool which enables you to fine tune complex queries via a series of forms thus allowing you to specify multiple criteria. It contains features such as automatic joins which allow you to very easily build up complex queries.

* Bookmarks - A feature I was completely unaware of that allows you to save queries for future use. This is particularly useful if you happen to be a database administrator that administers purely on a table by table basis within phpMyAdmin and has a number of queries to run. I always used to have popular queries I'd use stored in a notepad on my OS X Dashboard but no need anymore!

* System Documentation - I recently had a need to produce some MySQL documentation so was very happy to read this chapter and find out about the excellent documentation tools available within phpMyAdmin. This includes not only a basic print view, but also a data dictionary and a relational schema which are all exported as PDFs.

* MIME-Based Transformations - If you're the kind of developer that likes to store images, etc, as BLOB fields. With transformations, you can make images appear as images within the phpMyAdmin results rather than as indecipherable encoded text. Very useful!

* MySQL 5.0 and 5.1 - a quick look at the enhancements that MySQL 5 added with things such as views, routines, stored procedures, and very interestingly, triggers (a way to run other MySQL commands when a certain thing happens - e.g. when a table gets updated). You'd probably want a separate book to cover MySQL 5 if you were planning on doing any development with it, but this chapter gives you a good overview of some of the things you can expect.

* MySQL Server Administration - The final chapter deals with some of the more fundamental maintenance tasks related to the actual server and improvements that can be made with caching etc as well as a good comparison of the different types of storage engine you can choose.
Summary

All in all, I would highly recommend this book to any PHP developer or anybody that is using phpMyAdmin on a regular basis. It could really have been broken into two books - a beginners and an advanced - but it works well by acting as a reference for those developers that have grown up using phpMyAdmin. The main thing though is that it taught me a great deal about phpMyAdmin that I didn't realise was even there - just goes to show that even a basic sounding book can have a great deal to offer."
4.0 out of 5 stars Forgot I had it. Glad I found it. July 24 2014
By New Drupe - Published on Amazon.com
Format:Paperback|Verified Purchase
Not really a review but a story and a request for info. Well! What a nice surprise. I bought a book on a completely different area of life and Amazon asked me to review some of my purchases. It showed me this book and I thought, "I have never seen that book. I never ordered that, although it looks like something I would like." Back in 2010, I tried to make a push to learn web development tech, PHP, MySQL, and Joomla! CMS. I read several books but didn't get very far into a workable site before life took me away from it, until I recently started again, through Drupal CMS. So, I was curious, as it seemed like it could be helpful, and I went to a shelf I had not looked at in several years and there it was. I don't think I ever got to read it. I also don't know how much things have changed and if it is even still relevant. But I believe that I am glad I have it. I found a few more I forgot about also. I hope someone can tell me if it is still useful. Thanks Amazon, for reminding me that I have this book.
4.0 out of 5 stars Good book, not a necessity Dec 11 2009
By Kevin C. Giszewski - Published on Amazon.com
Format:Paperback|Verified Purchase
This book isn't bad but is very general and in the end didn't supplement a whole lot of things I didn't already know about the phpMyAdmin.

I recommend it for beginners to phpMyAdmin. Intermediate to advanced users may be disappointed.
0 of 1 people found the following review helpful
5.0 out of 5 stars PHP Reference Nov. 12 2010
By David Martin - Published on Amazon.com
Format:Paperback|Verified Purchase
For me, this is an excellent reference book. Loaded with info about PHP instructions I didn't realize existed (I have been building web applications with PHP for about two and half years now). I had used another book when I started learning PHP, but it didn't have a complete reference of available PHP command/instructions. I know I will keep this book handy, and have already found it very useful to accomplish some PHP tasks that I hadn't known I could do by trying to learn things via internet searches.
I do recommend this book and as far as I am concerned it is money well spent.

Look for similar items by category


Feedback