PacktLib: Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Credits

About the Author

About the Reviewers

Preface

Getting Started with phpMyAdmin

Introducing phpMyAdmin

Installing phpMyAdmin

Configuring phpMyAdmin

Upgrading phpMyAdmin

Summary

Configuring Authentication and Security

Logging in to MySQL through phpMyAdmin

Securing phpMyAdmin

Summary

Over Viewing the Interface

Over viewing panels and windows

Customizing general settings

Character sets, collations, and language

Navigation panel

Main panel

Query window

Summary

Taking First Steps

Creating a database

Creating our first table

Inserting data manually

Browse mode

Creating an additional table

Summary

Changing Data and Structure

Changing data

Changing a table's structure

Summary

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

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

Searching Data

Using Search page daily

Single-table searches

Performing a complete database search

Summary

Performing Table and Database Operations

Maintaining a table

Changing table attributes

Renaming, moving, and copying tables

Multi-table operations

Database operations

Summary

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

Entering SQL Commands

The SQL query box

The Query window

Multi-statement queries

Pretty printing (syntax-highlighting)

The SQL Validator

Summary

Generating Multi-table Queries

Choosing tables

Exploring column criteria

Generating automatic joins

Executing the query

Summary

Synchronizing Data and Supporting Replication

Synchronizing data and structure

Supporting MySQL replication

Summary

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

Documenting the System

Producing structure reports

Generating relational schemas in PDF

Summary

Transforming Data Using MIME

Browsing data without transformations

Enabling transformations

Examples of transformations

Summary

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

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

Administrating the MySQL Server with phpMyAdmin

Managing users and their privileges

Database information

Server information

Summary

The History of phpMyAdmin

The History of phpMyAdmin

The History of phpMyAdmin

The History of phpMyAdmin

The History of phpMyAdmin

The History of phpMyAdmin

The 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