Free Sample
+ Collection
Code Files

Mastering phpMyAdmin 3.4 for Effective MySQL Management

Marc Delisle

A complete guide to getting started with phpMyAdmin 3.4 and mastering its features book and ebook
RRP $23.99
RRP $39.99
Print + eBook

Want this title & more?

$12.99 p/month

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.

Book Details

ISBN 139781849517782
Paperback394 pages

About This Book

  • A step-by-step tutorial for manipulating data with the latest version of phpmyadmin
  • Administer your MySQL databases with phpMyAdmin
  • Manage users and privileges with MySQL Server Administration tools
  • 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, system administrator, or web designer who wants to manage MySQL databases and tables efficiently, then this book is for you. This book assumes that you are already wellacquainted 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
PHP and MySQL: The leading open source duo
What is phpMyAdmin?
Installing phpMyAdmin
Configuring phpMyAdmin
Installing phpMyAdmin configuration storage
Upgrading phpMyAdmin
Chapter 2: Configuring Authentication and Security
Logging in to MySQL through phpMyAdmin
Securing phpMyAdmin
Chapter 3: Over Viewing the Interface
Over viewing panels and windows
Customizing general settings
Character sets and collations
Navigation panel
Main panel
User preferences
Query window
Chapter 4: Creating and Browsing Tables
Creating a database
Creating our first table
Inserting data manually
Browse mode
Profiling queries
Creating an additional table
Chapter 5: Changing Data and Structure
Changing data
Changing table structure
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
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
Chapter 8: Searching Data
Single-table searches
Performing a complete database search
Stopping an errant query
Chapter 9: Performing Table and Database Operations
Maintaining a table
Changing table attributes
Emptying or deleting a table
Renaming, moving, and copying tables
Performing other table operations
Multi-table operations
Database operations
Chapter 10: Benefiting from the Relational System
Relational MySQL
Defining relations with the relation view
Defining relations with the Designer
Benefiting from the defined relations
Column commenting
Chapter 11: Entering SQL Statements
The SQL query box
The Query window
Multi-statement queries
Pretty printing (syntax highlighting)
The SQL Validator
Chapter 12: Generating Multi-table Queries
Choosing tables
Exploring column criteria
Generating automatic joins (internal relations)
Executing the query
The visual builder
Chapter 13: Synchronizing Data and Supporting Replication
Synchronizing data and structure
Supporting MySQL replication
Chapter 14: Using Query Bookmarks
Comparing bookmark and query history features
Creating bookmarks
Recalling bookmarks from the bookmarks list
Passing a parameter to a bookmark
Chapter 15: Documenting the System
Producing structure reports
Generating relational schemas
Chapter 16: Transforming Data using MIME
Browsing data without transformations
Enabling transformations
Examples of transformations
Chapter 17: Supporting Features Added in MySQL 5
Supporting views
Supporting routines—stored procedures and functions
Executing code with triggers
Using information_schema
Exploring the event scheduler
Chapter 18: Tracking Changes
Understanding the goals of the tracking system
Initiating tracking for one table
Testing the tracking mechanism
Determining tracking status
Structure snapshot
Exporting a version
Creating a new version
Deleting tracking information
Chapter 19: Administrating the MySQL Server
Managing users and their privileges
Database information
Server information

What You Will Learn

  • Upload phpMyAdmin to your web server and upgrade to the latest version
  • Protect authentication credentials according to the needs of a users group
  • Manage multiple MySQL servers using a single copy of phpMyAdmin
  • Export a table's structure and data for backup purposes
  • Define inter-table relations in a relational system
  • Enter your own SQL queries to perform actions that are beyond the scope of the interface and keep a history of these queries
  • Administer users accounts and privileges
  • Troubleshoot common problems encountered in phpMyAdmin and avoid these problems from re-occurring


In Detail

phpmyAdmin is one of the most widely used open source applications, which is written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 52 languages.

phpMyAdmin is a web-based front-end to manage MySQL databases and has been adopted by a number of Open-Source distributors.

Mastering phpMyAdmin 3.4 for Effective MySQL Management is an easy-to-read, step-by-step practical guide that walks you through every facet of this legendary tool—phpMyAdmin—and takes you a step ahead in taking full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.

This is the official guide to this popular MySQL web interface. It starts with installing and configuring phpMyAdmin, including the phpMyAdmin Configuration Storage, which is the key to its advanced features. This is followed by configuring authentication in phpMyAdmin and setting parameters that influence the interface as a whole.

You will also learn some advanced features such as defining inter-table relations with the advanced Designer module. You will practice synchronizing databases on different servers and managing MySQL replication to improve performance and data security. Moreover, you will also store queries as bookmarks for their quick retrieval.

In addition to it, this book helps you to learn new features introduced in version 3.4.x such as users’ preferences, producing charts and the visual multi-table query builder.


Read More

Recommended for You

Mastering phpMyAdmin 3.3.x 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