Mastering phpMyAdmin 2.11 for effective MySQL management : increase your MySQL productivity and control by discovering the real power of phpMyAdmin 2.11 / Marc Delisle.

Format:

Book

Author/Creator:

Delisle, Marc.

Language:

English

Subjects (All):

MySQL (Electronic resource).

Database management.

PHP (Computer program language).

Relational databases.

Physical Description:

1 online resource (340 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, U.K. : Packt, 2008.

Language Note:

English

Summary:

This book is an upgrade from the previous version that covered phpMyAdmin Version 2.8. Version 2.10 introduced a new GUI for relations, called Designer, and version 2.11 adds support for creating Views from query results, manages triggers, procedures and functions and has an improved interface for servers handling large number of databases/tables. Whether you are an experienced developer, system administrator, web designer or new to MySQL, phpMyAdmin is a must-have tool for anyone who needs to manage MySQL databases and tables. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.

Contents:

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

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

Database View

Table View

Server View

Icons for Home Page and Menu Tabs

Site-Specific Header and Footer

MySQL Documentation Links

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

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

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

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

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 Using LOAD DATA

Requirements

Using the LOAD DATA Interface

Web Server Upload Directories

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

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

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

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

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

Making the Validator Available

Validator Results

Standard-Conforming Queries

Non Standard-Conforming Queries

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

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

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

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

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

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

Kanji Support

Chapter 18: MySQL 5.0 Features

Observations on the History of MySQL 5.0

Manually Creating a View

Right Panel and Views

Creating a View from Results

Renaming a View

Performance Hint.

Routines: Stored Procedures and Functions.

Notes:

Includes index.

ISBN:

1-281-23678-0

1-84719-419-2

OCLC:

324806127