PacktLib: Mastering phpMyAdmin 3.1 for Effective MySQL Management

Mastering phpMyAdmin 3.1 for Effective MySQL Management

Credits

About the author

About the reviewer

Preface

Introduction and Installation

Introducing phpMyAdmin

Installing phpMyAdmin

Configuring phpMyAdmin

Upgrading phpMyAdmin

Summary

Authentication and Security

MySQL authentication

Security

Summary

Interface Overview

Panels and windows

General customization

Character sets, collations and language

Left panel (navigation)

Right panel (main)

Query window

Summary

First Steps

Database creation

Creating our first table

Manual data insertion

Browse mode

Creating an additional table

Summary

Changing Data

Edit mode

Multi-row editing

Editing the next row

Deleting data

Deleting tables

Deleting databases

Summary

Changing Table Structures

Adding a field

Editing field attributes

TEXT

BLOB (Binary Large Object) fields

ENUM and SET

DATE, DATETIME, and TIMESTAMP

Bit

Index management

Summary

Exporting Structure and Data (Backup)

Dumps, backups, and exports

Database exports

Table exports

Selective exports

Multi-database exports

Saving the export file on the server

Memory limits

Summary

Importing Structure and Data

Limits for the transfer

Importing SQL files

Importing CSV files

Web server upload directories

Summary

Searching Data

Daily usage of phpMyAdmin

Single-table searches

Complete database search

Summary

Table and Database Operations

Table maintenance

Changing table attributes

Renaming, moving, and copying tables

Multi-table operations

Database operations

Summary

The Relational System

Relational MySQL

Linked-tables infrastructure

Defining relations with the relation view

Defining relations with the Designer

Benefits of the defined relations

Column-commenting

Summary

Entering SQL Commands

The SQL query box

The Query window

Multi-statement queries

Pretty printing (syntax-highlighting)

The SQL Validator

Summary

The Multi-Table Query Generator

Choosing tables

Column criteria

Automatic joins

Executing the query

Summary

Bookmarks

Comparing bookmark and query history features

Bookmark creation

Recalling from the bookmarks list

Bookmark parameters

Executing bookmarks by browsing the pma_bookmark table

Summary

System Documentation

Structure reports

Relational schema in PDF

Summary

MIME-Based Transformations

Display behavior in browse mode

Enabling transformations

Examples of transformations

Summary

MySQL 5.0 and 5.1 Support

Views

Routines—stored procedures and functions

Triggers

Information_schema

Profiling

Partitioning

Event scheduler

BLOB streaming

Summary

MySQL Server Administration

User and privileges management

Database information

Server information

Summary

History of phpMyAdmin

History of phpMyAdmin

History of phpMyAdmin

History of phpMyAdmin

History of phpMyAdmin

History of phpMyAdmin

History of phpMyAdmin

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support