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.

Related Content you might be interested in

Current Title:

Small book image
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
Oct, 2010 | 412 pages
No titles found
Table of Contents (26 chapters)
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
Preface
Preface
Free Chapter
1
Getting Started with phpMyAdmin
Getting Started with phpMyAdmin
Introducing phpMyAdmin
Installing phpMyAdmin
Configuring phpMyAdmin
Upgrading phpMyAdmin
Summary
2
Configuring Authentication and Security
Configuring Authentication and Security
Logging in to MySQL through phpMyAdmin
Securing phpMyAdmin
Summary
3
Over Viewing the Interface
Over Viewing the Interface
Over viewing panels and windows
Customizing general settings
Character sets, collations, and language
Navigation panel
Main panel
Query window
Summary
4
Taking First Steps
Taking First Steps
Creating a database
Creating our first table
Inserting data manually
Browse mode
Creating an additional table
Summary
5
Changing Data and Structure
Changing Data and Structure
Changing data
Changing a table's structure
Summary
6
Exporting Structure and Data (Backup)
Exporting Structure and Data (Backup)
Dumps, backups, and exports
Exporting a database
Exporting a table
Exporting selectively
Exporting multiple databases
Saving the export file on the server
Memory limits
Summary
7
Importing Structure and Data
Importing Structure and Data
Limits for the transfer
Importing SQL files
Importing CSV files
Importing other formats
Reading files from a web server upload directory
Displaying an upload progress bar
Displaying a character set dialog
Summary
8
Searching Data
Searching Data
Using Search page daily
Single-table searches
Performing a complete database search
Summary
9
Performing Table and Database Operations
Performing Table and Database Operations
Maintaining a table
Changing table attributes
Renaming, moving, and copying tables
Multi-table operations
Database operations
Summary
10
Benefiting from the Relational System
Benefiting from the Relational System
Relational MySQL
Linked-tables infrastructure
Defining relations with the relation view
Defining relations with the Designer
Benefiting from the defined relations
Column-commenting
Summary
11
Entering SQL Commands
Entering SQL Commands
The SQL query box
The Query window
Multi-statement queries
Pretty printing (syntax-highlighting)
The SQL Validator
Summary
12
Generating Multi-table Queries
Generating Multi-table Queries
Choosing tables
Exploring column criteria
Generating automatic joins
Executing the query
Summary
13
Synchronizing Data and Supporting Replication
Synchronizing Data and Supporting Replication
Synchronizing data and structure
Supporting MySQL replication
Summary
14
Using Bookmarks
Using Bookmarks
Comparing bookmark and query history features
Creating bookmarks
Recalling bookmarks from the bookmarks list
Bookmark parameters
Executing bookmarks by browsing the pma_bookmark table
Summary
15
Documenting the System
Documenting the System
Producing structure reports
Generating relational schemas in PDF
Summary
16
Transforming Data Using MIME
Transforming Data Using MIME
Browsing data without transformations
Enabling transformations
Examples of transformations
Summary
17
Supporting MySQL 5.0 and 5.1
Supporting MySQL 5.0 and 5.1
Activating support for views
Supporting routines stored procedures and functions
Executing code with triggers
Using information_schema
Profiling
Partitioning
Exploring the Event Scheduler
BLOB streaming
Summary
18
Tracking Changes
Tracking Changes
Understanding the goals of the tracking system
Prerequisites
Principles
Initiating tracking for one table
Testing the tracking mechanism
Determining tracking status
Structure snapshot
Exporting a version
Creating a new version
Deleting tracking information
Summary
19
Administrating the MySQL Server with phpMyAdmin
Administrating the MySQL Server with phpMyAdmin
Managing users and their privileges
Database information
Server information
Summary
The History of phpMyAdmin
The History of phpMyAdmin
Early events
Project re-launch
Evolution
GoPHP5 and the 3.x branch
Awards
Future phpMyAdmin versions
Troubleshooting and Support
Troubleshooting and Support
System requirements
Verifying the base configuration
Solving common errors
Seeking support
FAQs
Help forums
Contributing to the project

GoPHP5 and the 3.x branch

phpMyAdmin accepted an invitation to become an initial member of the GoPHP5 initiative (see http://GoPHP5.org). This initiative promotes the adoption of PHP 5 among web hosts. This means that the new feature releases of phpMyAdmin, after February 05, 2008, require a server that can at least run PHP 5.2.

To better indicate the new PHP requirements, the team switched the major version number to 3. At the same time, it was decided to stop supporting MySQL prior to version 5.0 in the 3.x branch.

Version 3.0 was released on September 27, 2008, with support for MySQL 5.1 features, such as partitioning and the event scheduler. This version also had a new start page, and made use of JavaScript effects. Then, on November 11, 2008, version 3.1 incorporated a new setup script and support for BLOB streaming the work of two students from the Google Summer of Code (GSoC) 2008. This version also added support for Swekey hardware authentication.

In preparation for GSoC 2009, version 3.2 was released on June 9, 2009. It was time to release this version, which contained many small new features, before merging the upcoming GSoC work. At the end of summer 2009, four students were able to finish their GSoC phpMyAdmin projects, which included new export and import modules, synchronization, change tracking, and replication support. Afterwards, a period of testing and merging occurred for these features.

In February 2010, the second team meeting took place during the Free and Open Source Software Developers' European Meeting (http://fosdem.org/2010/) in Brussels, Belgium. Five members from Germany, the Czech Republic, The Netherlands, and Canada discussed the project and decided to switch the localization system to gettext and to move the code base to a git repository. I gave a talk titled "State of phpMyAdmin" in the MySQL developer room, where I mostly presented the new features for the upcoming new version.

Version 3.3 was released on March 7, 2010 and included the new features of GSoC 2009. Our project was selected by Google for GSoC 2010, this time as a full-fledged participating organization. Six students developed new aspects of phpMyAdmin for the upcoming 3.4 version.

phpMyAdmin continues to be popular. The cumulative downloads, since April 2001, have reached an impressive count of more than twenty million in June 2010, at the time of writing this book.

Previous Section
End of Section
Next Section