Mastering phpMyAdmin 3.3.x for Effective MySQL Management

A complete guide to get started with phpMyAdmin 3.3 and master its features

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Mastering
Marc Delisle

A complete guide to get started with phpMyAdmin 3.3 and master its features
$23.99
$39.99
RRP $23.99
RRP $39.99
eBook
Print + eBook
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
+ Collection
Free sample

Book Details

ISBN 139781849513548
Paperback412 pages

About This Book

  • The best introduction to phpMyAdmin available
  • Written by the project leader of phpMyAdmin, and improved over several editions
  • A step-by-step tutorial for manipulating data with phpMyAdmin
  • Learn to do things with your MySQL database and phpMyAdmin that you didn't know were possible!

 

Who This Book Is For

If you are a developer or system administrator or web designer who wants to manage MySQL databases and tables efficiently, this book is for you. This book assumes you already are well acquainted with MySQL basics. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.

Table of Contents

Chapter 1: Getting Started with phpMyAdmin
Introducing phpMyAdmin
Installing phpMyAdmin
Configuring phpMyAdmin
Upgrading phpMyAdmin
Summary
Chapter 2: Configuring Authentication and Security
Logging in to MySQL through phpMyAdmin
Securing phpMyAdmin
Summary
Chapter 3: Over Viewing the Interface
Over viewing panels and windows
Customizing general settings
Character sets, collations, and language
Navigation panel
Main panel
Query window
Summary
Chapter 4: Taking First Steps
Creating a database
Creating our first table
Inserting data manually
Browse mode
Creating an additional table
Summary
Chapter 5: Changing Data and Structure
Changing data
Changing a table's structure
Summary
Chapter 6: 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
Chapter 7: 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
Chapter 8: Searching Data
Using Search page daily
Single-table searches
Performing a complete database search
Summary
Chapter 9: Performing Table and Database Operations
Maintaining a table
Changing table attributes
Renaming, moving, and copying tables
Multi-table operations
Database operations
Summary
Chapter 10: 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
Chapter 11: Entering SQL Commands
The SQL query box
The Query window
Multi-statement queries
Pretty printing (syntax-highlighting)
The SQL Validator
Summary
Chapter 12: Generating Multi-table Queries
Choosing tables
Exploring column criteria
Generating automatic joins
Executing the query
Summary
Chapter 13: Synchronizing Data and Supporting Replication
Synchronizing data and structure
Supporting MySQL replication
Summary
Chapter 14: 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
Chapter 15: Documenting the System
Producing structure reports
Generating relational schemas in PDF
Summary
Chapter 16: Transforming Data Using MIME
Browsing data without transformations
Enabling transformations
Examples of transformations
Summary
Chapter 17: 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
Chapter 18: 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
Chapter 19: Administrating the MySQL Server with phpMyAdmin
Managing users and their privileges
Database information
Server information
Summary

What You Will Learn

  • Upload phpMyAdmin to your web server and upgrade to the latest version
  • Manage multiple servers using a single copy of phpMyAdmin
  • Protect authentication credentials according to the needs of a users' group and secure your phpMyAdmin installation using the various available authentication types
  • Export a table's structure and data for backup purposes and also use it as a gateway to another application
  • Import back a table's structure and data, provided the chosen format is supported by phpMyAdmin
  • Search for entries in a single-table by specifying the search criteria and also perform a search in the whole database
  • Define inter-table relations in a relational system and install the linked-tables infrastructure for keeping special metadata
  • Enter your own SQL queries into phpMyAdmin to perform actions that are beyond the scope of the interface and keep a history of these queries
  • Produce and maintain good documentation that explains the structure of your databases using the tools offered by phpMyAdmin
  • Apply transformations to data, in order to customize its format at view time
  • Administer a MySQL server by managing user accounts and privileges
  • Troubleshoot some common problems encountered in phpMyAdmin and prevent some of these problems from reoccurring
  • Save time while retrieving queries by storing them as bookmarks

 

In Detail

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.

Authors

Table of Contents

Chapter 1: Getting Started with phpMyAdmin
Introducing phpMyAdmin
Installing phpMyAdmin
Configuring phpMyAdmin
Upgrading phpMyAdmin
Summary
Chapter 2: Configuring Authentication and Security
Logging in to MySQL through phpMyAdmin
Securing phpMyAdmin
Summary
Chapter 3: Over Viewing the Interface
Over viewing panels and windows
Customizing general settings
Character sets, collations, and language
Navigation panel
Main panel
Query window
Summary
Chapter 4: Taking First Steps
Creating a database
Creating our first table
Inserting data manually
Browse mode
Creating an additional table
Summary
Chapter 5: Changing Data and Structure
Changing data
Changing a table's structure
Summary
Chapter 6: 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
Chapter 7: 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
Chapter 8: Searching Data
Using Search page daily
Single-table searches
Performing a complete database search
Summary
Chapter 9: Performing Table and Database Operations
Maintaining a table
Changing table attributes
Renaming, moving, and copying tables
Multi-table operations
Database operations
Summary
Chapter 10: 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
Chapter 11: Entering SQL Commands
The SQL query box
The Query window
Multi-statement queries
Pretty printing (syntax-highlighting)
The SQL Validator
Summary
Chapter 12: Generating Multi-table Queries
Choosing tables
Exploring column criteria
Generating automatic joins
Executing the query
Summary
Chapter 13: Synchronizing Data and Supporting Replication
Synchronizing data and structure
Supporting MySQL replication
Summary
Chapter 14: 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
Chapter 15: Documenting the System
Producing structure reports
Generating relational schemas in PDF
Summary
Chapter 16: Transforming Data Using MIME
Browsing data without transformations
Enabling transformations
Examples of transformations
Summary
Chapter 17: 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
Chapter 18: 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
Chapter 19: Administrating the MySQL Server with phpMyAdmin
Managing users and their privileges
Database information
Server information
Summary

Book Details

ISBN 139781849513548
Paperback412 pages
Read More

Recommended for You

Mastering phpMyAdmin 3.4 for Effective MySQL Management
$ 23.99
Mastering phpMyAdmin 3.1 for Effective MySQL Management
$ 20.99
Mastering phpMyAdmin 2.11 for Effective MySQL Management
$ 15.75
Dominar phpMyAdmin para una administración efectiva de MySQL [Espanol]
$ 12.00