PacktLib: Mastering phpMyAdmin 3.4 for Effective MySQL Management

Mastering phpMyAdmin 3.4 for Effective MySQL Management

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

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

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 and collations

Navigation panel

Main panel

User preferences

Query window

Summary

Creating and Browsing Tables

Creating a database

Creating our first table

Inserting data manually

Browse mode

Profiling queries

Creating an additional table

Summary

Changing Data and Structure

Changing data

Changing table 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

Summary

Searching Data

Single-table searches

Performing a complete database search

Stopping an errant query

Summary

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

Summary

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

Summary

Entering SQL Statements

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 (internal relations)

Executing the query

The visual builder

Summary

Synchronizing Data and Supporting Replication

Synchronizing data and structure

Supporting MySQL replication

Summary

Using Query Bookmarks

Comparing bookmark and query history features

Creating bookmarks

Recalling bookmarks from the bookmarks list

Passing a parameter to a bookmark

Summary

Documenting the System

Producing structure reports

Generating relational schemas

Summary

Transforming Data using MIME

Browsing data without transformations

Enabling transformations

Examples of transformations

Summary

Supporting Features Added in MySQL 5

Supporting views

Supporting routines—stored procedures and functions

Executing code with triggers

Using information_schema

Partitioning

Exploring the event scheduler

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

Managing users and their privileges

Database information

Server information

Summary

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Troubleshooting and Support

Index