Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Mar, 2008 | 340 pages
No titles found
Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
Preface
Preface
Free Chapter
1
Introducing phpMyAdmin
Introducing phpMyAdmin
PHP and MySQL: The Leading Open-Source Duo
What is phpMyAdmin?
History
Awards
phpMyAdmin Features Summary
Summary
2
Installing phpMyAdmin
Installing phpMyAdmin
System Requirements
Downloading the Files
Installation
First Connection Configuration
Multi-Server Configuration
Advanced Authentication
Security
Upgrading phpMyAdmin
Summary
3
Interface Overview
Interface Overview
Panels and Windows
Language Selection
Themes
Left Panel
Right Panel
Query Window
Site-Specific Header and Footer
MySQL Documentation Links
Summary
4
First Steps
First Steps
Database Creation
Creating Our First Table
Manual Data Insertion
Browse Mode
Creating an Additional Table
Summary
5
Changing Data
Changing Data
Edit Mode
Multi-Row Editing
Editing the Next Row
Deleting Data
Deleting Tables
Deleting Databases
Summary
6
Changing Table Structures
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
7
Exporting Structure and Data
Exporting Structure and Data
Dumps, Backups, and Exports
Database Exports
Table Exports
Selective Exports
Multi-Database Exports
Saving the Export File on the Server
Memory Limits
Summary
8
Importing Structure and Data
Importing Structure and Data
Limits for the Transfer
Importing SQL Files
Importing CSV Files
Web Server Upload Directories
Summary
9
Searching Data
Searching Data
Single-Table Searches
Complete Database Search
Summary
10
Table and Database Operations
Table and Database Operations
Table Maintenance
Changing Table Attributes
Renaming, Moving, and Copying Tables
Multi-Table Operations
Database Operations
Summary
11
The Relational System
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
12
Entering SQL Commands
Entering SQL Commands
The SQL Query Box
The Query Window
Multi-Statement Queries
Pretty Printing (Syntax-Highlighting)
The SQL Validator
Summary
13
The Multi-Table Query Generator
The Multi-Table Query Generator
Choosing Tables
Column Criteria
Automatic Joins
Executing the Query
Summary
14
Bookmarks
Bookmarks
Creating a Bookmark after a Successful Query
Storing a Bookmark before Sending a Query
Multi-Query Bookmarks
Recalling from the Bookmarks List
Public Bookmarks
The Default Initial Query for a Table
Bookmark Parameters
Executing Bookmarks by Browsing the pma_bookmark Table
Summary
15
System Documentation
System Documentation
The Database Print View
The Selective Database Print View
The Table Print View
The Data Dictionary
Relational Schema in PDF
Summary
16
MIME-Based Transformations
MIME-Based Transformations
The MIME Column's Settings
Requirements for Image Generation
Examples of Transformations
Summary
17
Character Sets and Collations
Character Sets and Collations
Language Files and UTF-8
Versions of MySQL Prior to 4.1.x
MySQL 4.1.x and Later
Kanji Support
Summary
18
MySQL 5.0 Features
MySQL 5.0 Features
Observations on the History of MySQL 5.0
Views
Routines: Stored Procedures and Functions
Triggers
Information_schema
Profiling
Summary
19
MySQL Server Administration
MySQL Server Administration
Entering the Server View
Database Information
Server Operations
Summary
20
Troubleshooting and Support
Troubleshooting and Support
System Requirements
Base Configuration
Solving Common Errors
Seeking Support
Contributing to the Project
Future phpMyAdmin Versions
Summary

About the Author

Marc Delisle is a member of the MySQL Developers Guild—which regroups community developers—because of his involvement with phpMyAdmin. He started to contribute to this popular MySQL web interface in December 1998, when he made the first multi-language version. He has been actively involved with this software project since May 2001 as a developer and project administrator.

Marc has worked since 1980 at Collège de Sherbrooke, Québec, Canada, as an application programmer and network manager. He has also been teaching networking, security, and PHP/MySQL application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina.

Marc lives in Sherbrooke with his wife and they enjoy spending time with their four children.

This book is Marc's first one, and was followed by "Creating your MySQL Database: Practical Design Tips and Techniques", also with Packt Publishing.

I am truly grateful to Louay Fatoohi who approached me for this book project, and to the Packt team whose sound comments were greatly appreciated during the production. My thanks also go to Garvin Hicking, Alexander Marcus Turek, and Kai 'Oswald' Seidler, the reviewers for the successive editions of this book. Their sharp eyes helped in making this book clearer and more complete.

Finally, I wish to thank all contributors to phpMyAdmin's source code, translations, and documentation; the time they gave to this project still inspires me and continues to push me forward.

To Carole, André, Corinne, Annie, and Guillaume, with all my love.

Previous Section
Next Chapter