Book Image

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Book Image

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Overview of this book

phpMyAdmin is an open source tool written in PHP to handle MySQL administration over the World Wide Web. It can execute SQL statements and manage users and their permissions. However, when it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators are left baffled.Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy-to-follow, step-by-step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutorial approach to take full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.The book helps you get started with installing and configuring phpMyAdmin and looks at its features. You then work on a sample project with two basic tables and perform basic actions such as creating, editing, and deleting data, tables, and databases. You will learn how to create up-to-date backups and import the data that you have exported. You will then explore different search mechanisms and options for querying across multiple tables.The book gradually proceeds to advanced features such as defining inter-table relations and installing the linked-tables infrastructure. Some queries are out of the scope of the interface and this book will show you how to accomplish these tasks with SQL commands.New features of version 3.3.x, such as synchronizing databases on different servers and managing MySQL replication to improve performance and data security, are covered in this book. Towards the end of the book you will learn to document your database, track changes made to the database, and manage user accounts using phpMyAdmin server management features.This book is an upgrade from the previous version that covered phpMyAdmin Version 3.1. Version 3.3.x introduced features such as new import and export modules, tracking changes, synchronizing structure and data between servers, and providing support for replication.
Table of Contents (26 chapters)
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Project re-launch


However, the user base had already multiplied, and they were asking for more of the product. Patches were floating on the Internet, with no way of coordinating them. A security alert (and fix) had been published by a third-party, but no new version was being released. Finally, on March 31, 2001, Olivier Müller registered the phpMyAdmin project on SourceForge.net, and released a 2.2.0 pre-launch version. This was called the unofficial version. This restart of the project attracted some developers, who now had the SourceForge infrastructure (CVS server, forums, bug trackers, and mailing lists) to help speed up the development. I personally re-joined the project in May 2001, and started fixing and improving the code, as my co-developers were also doing.

We became official on May 28, 2001, as Tobias accepted our version as the new official one. I remember those months of very intense development effort, with daily improvements and bug fixes, along with new documentation sections. This effort culminated on August 31, 2001, with the release of version 2.2.0.

Here's an excerpt from the announcement file for 2.2.0:

After five months, five beta releases, and four release candidate versions, the phpMyAdmin developers are pleased to announce the availability of phpMyAdmin 2.2.0. [...] on March 31, 2001. Olivier Müller (Switzerland), supported by Marc Delisle (Québec), Loïc Chapeaux (France), and a team of eight other developers re-started the phpMyAdmin project on SourceForge.net, with the authorization of the original package maintainer. Now, after five months of patches, bug fixes, new features, and testing, the version 2.2.0 is finally ready.

This version had security fixes and seven new languages (with dynamic language detection). The code had been reworked to be CSS2 and XHTML 1.0 compliant, and to follow the PEAR coding guidelines. The bookmarks feature appeared in this version, and this came from a separate add-on called "phpMyBookmark".

During the following year, the development continued, with the release of seven minor versions. The last version of the 2.2.x series is 2.2.7-pl1, which is also the last to have been fully tested under PHP 3. We registered phpmyadmin.net as the official domain name for the project on April 03, 2002 the date is worth being noted.

Distributors

The list of distributors for phpMyAdmin would be too long and complex to gather, but here are a few pointers. First, the Downloads page of MySQL's website had a "contrib" section in which phpMyAdmin was mentioned very early after its birth. Also, many, if not all, Linux distributors included phpMyAdmin in their kit. Finally, a number of package builders prepare kits for various platforms. I'll just mention the renowned XAMPP kit from Apache Friends, available at http://www.xampp.org. Back in mid-2002, the Apache Friends group (led by Kai Seidler) was already busy integrating Apache, PHP, MySQL, and phpMyAdmin.