Cover -- Table of Contents -- Preface -- Chapter 1: Introducing phpMyAdmin -- PHP and MySQL: The Leading Open-Source Duo -- What is phpMyAdmin? -- History -- Awards -- phpMyAdmin Features Summary -- Summary -- Chapter 2: Installing phpMyAdmin -- System Requirements -- GoPHP5 -- Downloading the Files -- Installation -- Installation on a Remote Server Using a Windows Client -- Installation on a Local Linux Server -- Installation on Local Windows Servers (Apache, IIS) -- First Connection Configuration -- Configuration Principles -- Web-Based Setup Script -- Manual Creation of config.inc.php -- Tips for Editing config.inc.php on a Windows Client -- The config.inc.php File -- PmaAbsoluteUri -- Server-Specific Sections -- extension -- PersistentConnections -- connect_type, socket and port -- compress Configuration -- Authentication Type: config -- Testing the First Connection -- Multi-Server Configuration -- Servers Defined in the Configuration File -- Arbitrary Server -- Advanced Authentication -- Authentication Types Offered -- The Control User -- Logging Out -- HTTP Authentication -- Cookie Authentication -- Signon -- Security -- Directory-Level Protection -- IP-Based Access Control -- Rules -- Order of Interpretation for Rules -- Simplified Rule for Root Access -- Restricting the List of Databases -- Protecting In-Transit Data -- Upgrading phpMyAdmin -- Summary -- Chapter 3: Interface Overview -- Panels and Windows -- Login Panels -- Left and Right Panels -- Home Page -- Views -- Query Window -- Starting Page -- Window Titles Configuration -- General Icon Configuration -- Natural Sort Order for Database and Table Names -- Language Selection -- Themes -- Theme Configuration -- Theme Selection -- Left Panel -- Logo Configuration -- Database and Table List -- Light Mode -- Full Mode -- Table Short Statistics -- Quick-Browsing a Table.

Nested Display of Tables within a Database -- Server-List Choice -- Handling Many Databases or Tables -- Right Panel -- Home Page -- Database View -- Table View -- Server View -- Icons for Home Page and Menu Tabs -- Query Window -- Site-Specific Header and Footer -- MySQL Documentation Links -- Summary -- Chapter 4: First Steps -- Database Creation -- No Privileges? -- First Database Creation Is Authorized -- Creating Our First Table -- Choosing the Fields -- Table Creation -- Choosing Keys -- Manual Data Insertion -- Data Entry Panel Tuning for CHAR and VARCHAR -- Browse Mode -- SQL Query Links -- Navigation Bar -- Query Results Operations -- Sorting Results -- Color-Marking Rows -- Limiting the Length of Each Column -- Browsing Distinct Values -- Browse-Mode Customization -- Creating an Additional Table -- Summary -- Chapter 5: Changing Data -- Edit Mode -- Moving to Next Field with the Tab Key -- Moving with Arrows -- Handling NULL Values -- Applying a Function to a Value -- Duplicating Rows of Data -- Multi-Row Editing -- Editing the Next Row -- Deleting Data -- Deleting a Single Row -- Deleting Many Rows -- Deleting All the Rows in a Table -- Deleting All Rows in Many Tables -- Deleting Tables -- Deleting Databases -- Summary -- Chapter 6: Changing Table Structures -- Adding a Field -- Vertical Mode -- Horizontal Mode -- Editing Field Attributes -- TEXT -- BLOB (Binary Large Object) Fields -- Binary Contents Uploads -- ENUM and SET -- DATE, DATETIME, and TIMESTAMP -- Calendar Popup -- TIMESTAMP Options -- Bit -- Index Management -- Single-Field Indexes -- Multi-Field Indexes and Index Editing -- FULLTEXT Indexes -- Table Optimization: Explaining a Query -- Detection of Index Problems -- Summary -- Chapter 7: Exporting Structure and Data -- Dumps, Backups, and Exports -- Database Exports -- The Export Sub-Panel -- SQL Options.

The Save as file Sub-Panel -- File Name Template -- Compression -- Choice of Character Set -- CSV -- CSV for MS Excel -- PDF -- Microsoft Word 2000 -- Native MS Excel (pre-Excel 2000) -- Open Document Text -- YAML -- Table Exports -- Split-File Exports -- Selective Exports -- Exporting Partial Query Results -- Exporting and Checkboxes -- Multi-Database Exports -- Saving the Export File on the Server -- User-Specific Save Directories -- Memory Limits -- Summary -- Chapter 8: Importing Structure and Data -- Limits for the Transfer -- Time Limits -- Other Limits -- Partial Imports -- Temporary Directory -- Importing SQL Files -- Importing CSV Files -- Differences between SQL and CSV Formats -- Exporting a Test File -- CSV -- CSV Using LOAD DATA -- Requirements -- Using the LOAD DATA Interface -- Web Server Upload Directories -- Summary -- Chapter 9: Searching Data -- Single-Table Searches -- Daily Usage of phpMyAdmin -- Entering the Search Sub-Page -- Selection of Display Fields -- Ordering the Results -- Search Criteria by Field: Query by Example -- Print View -- Wildcard Searching -- Combining Criteria -- Applying a WHERE Clause -- Obtaining Distinct Results -- Complete Database Search -- Summary -- Chapter 10: Table and Database -- Table Maintenance -- Changing Table Attributes -- Table Type -- Table Comments -- Table Order -- Table Options -- Renaming, Moving, and Copying Tables -- Appending Data to a Table -- Multi-Table Operations -- Repairing an "in use" Table -- Database Operations -- Renaming a Database -- Copying a Database -- Summary -- Chapter 11: The Relational System -- Relational MySQL? -- InnoDB -- Linked-Tables Infrastructure -- Goal of the Infrastructure -- Location of the Infrastructure -- Installing Linked-Tables Infrastructure -- Multi-User Installation -- Single-User Installation -- Defining Relations with the Relation View.

Internal Relations -- Defining the Relation -- Defining the Display Field -- InnoDB Relations -- InnoDB Tables without Linked-Tables Infrastructure -- Defining Relations with the Designer -- Interface Overview -- Defining Relations -- InnoDB Relations -- Defining the Display Field -- Exporting for PDF Schema -- Benefits of the Defined Relations -- Foreign Key Information -- The Drop-Down List of Foreign Keys -- The Browseable Foreign-Table Window -- Referential Integrity Checks -- Automatic Updates of Metadata -- Column-Commenting -- Automatic Migration -- Summary -- Chapter 12: Entering SQL Commands -- The SQL Query Box -- The Database View -- The Table View -- The Fields Selector -- Clicking Into the Query Box -- The Query Window -- Query Window Options -- Session-Based SQL History -- Database-Based SQL History (Permanent) -- Editing Queries in the Query Window -- Multi-Statement Queries -- Pretty Printing (Syntax-Highlighting) -- The SQL Validator -- System Requirements -- Making the Validator Available -- Validator Results -- Standard-Conforming Queries -- Non Standard-Conforming Queries -- Summary -- Chapter 13: The Multi-Table Query -- Choosing Tables -- Column Criteria -- Field Selector: Single-Column or All Columns -- Sorts -- Showing a Column -- Updating the Query -- Criteria -- Adjusting the Number of Criteria Rows -- Adjusting the Number of Criteria Columns -- Automatic Joins -- Executing the Query -- Summary -- Chapter 14: Bookmarks -- Creating a Bookmark after a Successful Query -- Storing a Bookmark before Sending a Query -- Multi-Query Bookmarks -- Recalling from the Bookmarks List -- Bookmark Execution -- Bookmark Manipulation -- Public Bookmarks -- The Default Initial Query for a Table -- Bookmark Parameters -- Creating a Parameterized Bookmark -- Passing a Parameter Value to a Bookmark.

Executing Bookmarks by Browsing the pma_bookmark Table -- Summary -- Chapter 15: System Documentation -- The Database Print View -- The Selective Database Print View -- The Table Print View -- The Data Dictionary -- Relational Schema in PDF -- Adding a Third Table to Our Model -- Editing PDF Pages -- Page Planning -- Creating a New Page -- Editing a Page -- Displaying a Page -- A Note about Fonts Used -- Using the Designer for PDF Layout -- Summary -- Chapter 16: MIME-Based Transformations -- The MIME Column's Settings -- MIME Types -- Browser Transformations -- Transformation Options -- Requirements for Image Generation -- The GD2 Library -- The JPEG and PNG Libraries -- Memory Limits -- Examples of Transformations -- Clickable Thumbnail (.jpeg or .png) -- Links to an Image -- Date Formatting -- Links from Text -- text/plain: link -- text/plain: imagelink -- Preserving the Original Formatting -- Displaying Parts of a Text -- Download Link -- Hexadecimal Representation -- SQL Pretty Printing -- External Applications -- External Application Example: In-Cell Sort -- Summary -- Chapter 17: Character Sets and Collations -- Language Files and UTF-8 -- Versions of MySQL Prior to 4.1.x -- Data Recoding -- Character Sets -- Choosing the Effective Character Set -- The Impact of Switching -- Importing and Exporting with Character Sets -- MySQL 4.1.x and Later -- Collations -- The Home Page -- Creating a Database -- Available Character Sets and Collations -- Effective Character Sets and Collations -- The Database View -- The Table View -- Importing and Exporting with Character Sets -- Server View -- Kanji Support -- Summary -- Chapter 18: MySQL 5.0 Features -- Observations on the History of MySQL 5.0 -- Views -- Manually Creating a View -- Right Panel and Views -- Creating a View from Results -- Renaming a View -- Performance Hint.

Routines: Stored Procedures and Functions.