Free Sample
+ Collection

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering
Marc Delisle

Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 2.11
$15.75
$34.99
RRP $20.99
RRP $34.99
eBook
Print + eBook

Want this title & more?

$21.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781847194183
Paperback340 pages

About This Book

  • Effectively administer your MySQL databases with phpMyAdmin.
  • Manage users and privileges with MySQL Server Administration tools.
  • Get to grips with the hidden features and capabilities of phpMyAdmin.

Who This Book Is For

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.

Table of Contents

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
Downloading the Files
Installation
First Connection Configuration
Multi-Server Configuration
Advanced Authentication
Security
Upgrading phpMyAdmin
Summary
Chapter 3: Interface Overview
Panels and Windows
Language Selection
Themes
Left Panel
Right Panel
Query Window
Site-Specific Header and Footer
MySQL Documentation Links
Summary
Chapter 4: First Steps
Database Creation
Creating Our First Table
Manual Data Insertion
Browse Mode
Creating an Additional Table
Summary
Chapter 5: Changing Data
Edit Mode
Multi-Row Editing
Editing the Next Row
Deleting Data
Deleting Tables
Deleting Databases
Summary
Chapter 6: 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
Chapter 7: 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
Chapter 8: Importing Structure and Data
Limits for the Transfer
Importing SQL Files
Importing CSV Files
Web Server Upload Directories
Summary
Chapter 9: Searching Data
Single-Table Searches
Complete Database Search
Summary
Chapter 10: Table and Database Operations
Table Maintenance
Changing Table Attributes
Renaming, Moving, and Copying Tables
Multi-Table Operations
Database Operations
Summary
Chapter 11: 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
Chapter 12: Entering SQL Commands
The SQL Query Box
The Query Window
Multi-Statement Queries
Pretty Printing (Syntax-Highlighting)
The SQL Validator
Summary
Chapter 13: The Multi-Table Query Generator
Choosing Tables
Column Criteria
Automatic Joins
Executing the Query
Summary
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
Public Bookmarks
The Default Initial Query for a Table
Bookmark Parameters
Executing Bookmarks by Browsing the pma_bookmark Table
Summary
Chapter 15: System Documentation
The Database Print View
The Selective Database Print View
The Table Print View
The Data Dictionary
Relational Schema in PDF
Summary
Chapter 16: MIME-Based Transformations
The MIME Column's Settings
Requirements for Image Generation
Examples of Transformations
Summary
Chapter 17: 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
Chapter 18: MySQL 5.0 Features
Observations on the History of MySQL 5.0
Views
Routines: Stored Procedures and Functions
Triggers
Information_schema
Profiling
Summary
Chapter 19: MySQL Server Administration
Entering the Server View
Database Information
Server Operations
Summary
Chapter 20: Troubleshooting and Support
System Requirements
Base Configuration
Solving Common Errors
Seeking Support
Contributing to the Project
Future phpMyAdmin Versions
Summary

What You Will Learn

  • Common reasons for installing PhpMyAdmin
  • Managing multiple servers on single copy of PhpMyAdmin
  • Securing your PhpMyAdmin installation
  • Upgrading your PhpMyAdmin installation
  • Managing databases, data table structures, and indexes to create efficient databases
  • Administering MySQL users and privileges
  • Getting server and database statistics
  • Generating better documentation of evolving table structures

Along the way you will build a more detailed understanding of SQL and how it works in MySQL.

In Detail

PhpMyAdmin is a well known and popular open-source tool written in PHP intended to handle the administration of MySQL over the Internet. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, and manage keys on fields. While most MySQL developers use routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool.

MySQL is the most popular open-source database, used by millions of developers and supporting numerous large dynamic websites and applications. MySQL acquired this wide popularity by virtue of its open-source nature, performance, reliability, robustness, and support for various platforms. This popularity has also been helped by the existence of phpMyAdmin, the industry-standard administration tool that makes database management easy for both the experienced developer and the novice.

The powerful graphical interface that it provides to MySQL has made phpMyAdmin an indispensable tool for MySQL and web developers. Every phpMyAdmin user can benefit from unlocking the full potential of this powerful application. Whether you are an experienced developer, system administrator, web designer, or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your databases.

Authors

Read More

Recommended for You

Mastering phpMyAdmin 3.4 for Effective MySQL Management
$ 23.99
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
$ 23.99
Mastering phpMyAdmin 3.1 for Effective MySQL Management
$ 20.99
Dominar phpMyAdmin para una administración efectiva de MySQL [Espanol]
$ 12.00