Mastering phpMyAdmin for Effective MySQL Management


There is a newer version of this book available - Mastering phpMyAdmin 3.1 for Effective MySQL Management
Mastering phpMyAdmin for Effective MySQL Management
eBook: $27.99
Formats: PDF, PacktLib, ePub and Mobi formats
$16.79
save 40%!
Print + free eBook + free PacktLib access to the book: $57.98    Print cover: $29.99
$26.99
save 53%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • Discover the real power of phpMyAdmin.
  • Increase your MySQL productivity and control.
  • Get to grips with the hidden features and capabilities of phpMyAdmin 
  • Updated for V 2.6.0 October 2004.

Book Details

Language : English
Paperback : 242 pages [ 210mm x 197mm ]
Release Date : October 2004
ISBN : 1904811035
ISBN 13 : 9781904811039
Author(s) : Marc Delisle
Topics and Technologies : All Books, Big Data and Business Intelligence, MySQL, Open Source
Sorry, the table of contents for this book is not yet available.

Marc Delisle

Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin. He started to contribute to the project in December 1998, when he made the multi-language version. He is still involved with phpMyAdmin as a developer and project administrator. Marc is a system administrator at Cegep de Sherbrooke, Québec, Canada. He has been teaching networking, security, and web application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina. Marc lives in Sherbrooke with his wife and they enjoy spending time with their four children.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Mastering phpMyAdmin for Effective MySQL Management +    Tapestry 5: Building Web Applications =
50% Off
the second eBook
Price for both: €21.49

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

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 databases. You will learn how to:

  • Administer MySQL users and privileges, and get statistics about MySQL servers and databases
  • Manage databases, table data and structures, and indexes
  • Use bookmarks and metadata
  • Generate multiple SQL queries
  • Generate better documentation of evolving table structures

Along the way you'll build a more detailed understanding of SQL and how it works in MySQL.

As an application developer you'll learn how to use phpMyAdmin to:

  • Effectively perform day-to-day database and table management.
  • Create better database tables and relational structures
  • More easily document your evolving data structure

As a MySQL server administrator, you'll benefit from the in-depth and practical coverage of:

  • Using phpMyAdmin to manage users and privileges
  • Getting server and database statistics

All database users will expand and refine their knowledge of SQL in a MySQL context through using phpMyAdmin to track SQL execution and results.

In Detail

phpMyAdmin
Providing a powerful graphical interface for managing MySQL, phpMyAdmin is one of the most popular open source applications. While most MySQL developers use the routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool.

MySQL
Used by millions of developers, MySQL is the most popular open source database, supporting numerous large dynamic websites and applications. MySQL has acquired this wide popularity by virtue of its open source nature, performance, reliability, robustness, and support for various platforms. However, this popularity has also been helped by the existence of phpMyAdmin, the industry-standard administration tool that makes database management easy for both the experienced developer and the novice. The powerful graphical interface that it provides to MySQL has made phpMyAdmin an indispensable tool for MySQL and web developers. Every phpMyAdmin user can benefit from unlocking the full potential of this powerful application.

This book is a comprehensive guide helping you to unlock the full potential of phpMyAdmin. 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.

If you find yourself writing a lot of throwaway admin interfaces and hating every minute of it, the $30 cover price for this text is probably looking mighty attractive right now. Deane Barker, Gadgetopia.com

Approach

The book begins with a comprehensive tutorial of phpMyAdmin that systematically explains and demonstrates the potential of this tool. It then goes on to show the less well known and generally under-used features and capabilities of phpMyAdmin in depth.

In the book you'll learn about:

  • Installing, configuring, and customizing phpMyAdmin.
  • MySQL administration.
  • Managing databases, table data and, structures.
  • Managing indexes.
  • Exporting databases and table data and structures.
  • Searching databases and tables
  • Using metadata and bookmarks
  • Generating multiple SQL queries
  • Documenting table structures
  • Mime-based transformation

Who this book is for

phpMyAdmin is a must have tool for everyone 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.

 

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software