Mastering phpMyAdmin 3.3.x for Effective MySQL Management: A complete guide to get started with phpMyAdmin 3.3 and master its features

412 Pages·2010·23.248 MB·English

by  Marc Delisle

www.it-ebooks.info
Mastering phpMyAdmin 3.3.x
for Effective MySQL Management
A complete guide to getting started with
phpMyAdmin 3.3 and mastering its features
Marc Delisle
BIRMINGHAM - MUMBAI
www.it-ebooks.info
Mastering phpMyAdmin 3.3.x
for Effective MySQL Management
Copyright © 2010 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval
system, or transmitted in any form or by any means, without the prior written
permission of the publisher, except in the case of brief quotations embedded in
critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy
of the information presented. However, the information contained in this book is
sold without warranty, either express or implied. Neither the author, nor Packt
Publishing, and its dealers and distributors will be held liable for any damages
caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the
companies and products mentioned in this book by the appropriate use of capitals.
However, Packt Publishing cannot guarantee the accuracy of this information.
First published: October 2010
Production Reference: 1041010
Published by Packt Publishing Ltd.
32 Lincoln Road
Olton
Birmingham, B27 6PA, UK.
ISBN 978-1-849513-54-8
www.packtpub.com
Cover Image by Marc Delisle ([email protected])
www.it-ebooks.info
Credits
Author Editorial Team Leader
Marc Delisle Akshara Aware
Reviewers Project Team Leader
Michal Čihař Lata Basantani
Ben Dodson
Kai 'Oswald' Seidler Project Coordinator
Sneha Harkut
Development Editor Proofreader
Reshma Sundaresan Dirk Manuel
Technical Editor
Production Coordinator
Conrad Sardinha
Adline Swetha Jesuthas
Indexer Cover Work
Hemangini Bari Adline Swetha Jesuthas
www.it-ebooks.info
About the Author
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 developed 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 taught 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.
This book was Marc's first one and was quickly followed by Creating your
MySQL Database: Practical Design Tips and Techniques, also published by
Packt Publishing.
I am truly grateful to Louay Fatoohi who approached me for this
book project, and to the Packt team whose sound comments were
greatly appreciated during the production. My thanks also go to the
excellent reviewers Kai 'Oswald' Seidler, Ben Dodson, and Michal
Čihař. Their sharp eyes helped in making this book clearer and more
complete.

Finally, I wish to thank all contributors to phpMyAdmin's source
code, translations, and documentation; their dedication to this
project continues to push me forward.
www.it-ebooks.info
About the Reviewers
Michal Čihař was born in 1980 in Prague, the capital city of the Czech Republic,
and he is still living there. He studied Software Engineering at the Czech Technical
University, and during these studies he started contributing to several free software
projects, with the biggest contributions being made to phpMyAdmin and Gammu,
and related projects. He currently works for Novell, mostly on the SUSE Linux
Enterprise platform.
Michal has been active in the phpMyAdmin project since 2001, when he started as
a translator for the Czech language, later moving to a developer role (working, for
example, on index manipulation, and export and import subsystems), and since 2010
he has also acted as a secondary project manager.
Ben Dodson has worked with the Internet for over 15 years, yet originally studied
Politics. He trained briefly as an Air Traffic Controller for the RAF before deciding
to change career paths and work as a freelance HTML/PHP developer, in Devon.
He relocated to London to work for a digital agency, and was rapidly promoted to
Development Manager in charge of a team of front- and back-end web developers in
several countries.
After working for a few more agencies, he decided to return to freelancing but this
time as an iPhone Developer. He now splits his time in Central London between
working on his own applications and working on applications for brand-name
clients, incorporating everything from store locators to iPad magazine concepts.
Ben still maintains a strong connection to his web development roots by working on
APIs for geo-coded Wikipedia Articles (www.wikilocation.org) and the London
Underground (www.tubeupdates.com). One of his main interests is in the power of
location-aware applications and so he has spent a lot of time developing Gowalla
Tools, a suite of applications that utilize the popular Gowalla geo-location service.
www.it-ebooks.info
Aside from his websites and iPhone applications, Ben enjoys working on
everything from browser extensions to OpenID servers. He is a keen photographer
and designer, and is currently working on his first book, which discusses
Machiavellian republicanism.
Ben has been invited to speak at several conferences and has appeared on BBC
Television's "Working Lunch" program to discuss e-commerce, and also Channel
Five's "The Gadget Show" to demonstrate iPhone Application development.
Kai 'Oswald' Seidler was born in Hamburg in 1970. He graduated from the
Technical University of Berlin with a Diplom Informatiker degree (Master of Science
equivalent) in Computer Science. In the '90s he created and managed Germany's
biggest IRCnet server, irc.fu-berlin.de, and co-managed one of the world's
largest anonymous FTP servers, ftp.cs.tu-berlin.de. He professionally set
up his first public web server in 1993. From 1993 until 1998, he was a member of
Projektgruppe Kulturraum Internet, a research project on net culture and network
organization. In 2002, he co-founded Apache Friends and created the multi-platform
Apache web server bundle XAMPP. Around 2005, XAMPP became the most popular
Apache stack worldwide. In 2006, his third book, Das XAMPP-Handbuch, was
published by Addison Wesley.
Currently he's working as a technology evangelist for web tier products at Sun
Microsystems.
www.it-ebooks.info
www.it-ebooks.info
www.it-ebooks.info
To Carole, André, Corinne, Annie, and Guillaume, with all my love.
www.it-ebooks.info