Mastering phpMyAdmin 3.1 for Effective MySQL Management

Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1
Mastering phpMyAdmin 3.1 for Effective MySQL Management Book Cover

Mastering phpMyAdmin 3.1 for Effective MySQL Management

This ebook is included in a Mapt subscription
Marc Delisle

Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1
$0.00
$10.50
$34.99
$29.99p/m after trial
RRP $20.99
RRP $34.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Code Files
Preview in Mapt

Book Details

ISBN 139781847197863
Paperback352 pages

Book Description

MySQL has gained wide popularity because of its open-source nature, performance, reliability, robustness, and support for various platforms.

phpMyAdmin is a web-based front-end to manage MySQL databases and has been adopted by a number of open-source distributors. It is one of the most widely used open-source applications written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 52 languages. The powerful graphical interface of version 3.1 has made phpMyAdmin an indispensable tool for MySQL and web developers.

This is the first book that covers version 3.1, the latest version of phpMyAdmin. It has been fully updated from the previous version that covered phpMyAdmin Version 2.11. It is a comprehensive guide to unlocking the full potential of phpMyAdmin. It builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet right from showing you how to set up and manage the database with clear, step-by-step instructions and screenshots to exploring the less well known and generally under-used features and capabilities of phpMyAdmin in depth. Along the way you'll build a more detailed understanding of SQL and how it works in MySQL.

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 MySQL.

Table of Contents

Chapter 1: Introduction and Installation
Introducing phpMyAdmin
Installing phpMyAdmin
Configuring phpMyAdmin
Upgrading phpMyAdmin
Summary
Chapter 2: Authentication and Security
MySQL authentication
Security
Summary
Chapter 3: Interface Overview
Panels and windows
General customization
Character sets, collations and language
Left panel (navigation)
Right panel (main)
Query window
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 (Backup)
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
Daily usage of phpMyAdmin
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
Comparing bookmark and query history features
Bookmark creation
Recalling from the bookmarks list
Bookmark parameters
Executing bookmarks by browsing the pma_bookmark table
Summary
Chapter 15: System Documentation
Structure reports
Relational schema in PDF
Summary
Chapter 16: MIME-Based Transformations
Display behavior in browse mode
Enabling transformations
Examples of transformations
Summary
Chapter 17: MySQL 5.0 and 5.1 Support
Views
Routines—stored procedures and functions
Triggers
Information_schema
Profiling
Partitioning
Event scheduler
BLOB streaming
Summary
Chapter 18: MySQL Server Administration
User and privileges management
Database information
Server information
Summary

What You Will Learn

  • Administer MySQL users and get statistics about MySQL servers and databases
  • Create better database tables and relational structures
  • Generate multiple SQL queries and build a more detailed understanding of SQL and its workings
  • Prepare better documentation of evolving table structures
  • Manage databases, table data and structures, and indexes to create efficient databases
  • Learn the different mechanisms involved in importing SQL and CSV files
  • Examine the modified behavior of phpMyAdmin to use the outstanding application to its full power
  • Perform day-to-day database and table management effectively with the new interface to ease your work

Authors

Table of Contents

Chapter 1: Introduction and Installation
Introducing phpMyAdmin
Installing phpMyAdmin
Configuring phpMyAdmin
Upgrading phpMyAdmin
Summary
Chapter 2: Authentication and Security
MySQL authentication
Security
Summary
Chapter 3: Interface Overview
Panels and windows
General customization
Character sets, collations and language
Left panel (navigation)
Right panel (main)
Query window
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 (Backup)
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
Daily usage of phpMyAdmin
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
Comparing bookmark and query history features
Bookmark creation
Recalling from the bookmarks list
Bookmark parameters
Executing bookmarks by browsing the pma_bookmark table
Summary
Chapter 15: System Documentation
Structure reports
Relational schema in PDF
Summary
Chapter 16: MIME-Based Transformations
Display behavior in browse mode
Enabling transformations
Examples of transformations
Summary
Chapter 17: MySQL 5.0 and 5.1 Support
Views
Routines—stored procedures and functions
Triggers
Information_schema
Profiling
Partitioning
Event scheduler
BLOB streaming
Summary
Chapter 18: MySQL Server Administration
User and privileges management
Database information
Server information
Summary

Book Details

ISBN 139781847197863
Paperback352 pages
Read More

Read More Reviews

DEAL OF THE DAY

Sign up here to get exclusive deep discounts on our latest and bestselling eBooks, delivered straight to your inbox every day.

FREE LEARNING FOREVER

Master new IT skills and unlock valuable software & web development knowledge with a FREE eBook every day.

Recommended for You

JBoss AS 7 Configuration, Deployment and Administration Book Cover
JBoss AS 7 Configuration, Deployment and Administration
$ 29.99
$ 15.00
This book is the complete guide to JBoss AS 7 for Java system administrators, developers, and application testers. It takes you through setting up a JBoss application in logical, progressive steps, supported by screenshots and clear directions.
JSF 2.0 Cookbook Book Cover
JSF 2.0 Cookbook
$ 26.99
$ 13.50
Over 100 simple but incredibly effective recipes for taking control of your JSF applications
.NET Compact Framework 3.5 Data Driven Applications Book Cover
.NET Compact Framework 3.5 Data Driven Applications
$ 29.99
$ 15.00
Build robust and feature-rich mobile data-driven applications with the help of real-world examples
Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 12.00
Web pages that respond immediately to different screen sizes and devices is one of today’s essentials. Packed with screenshots and examples, this book will teach you the professional approach using just HTML5 and CSS3.
Apache Maven 3 Cookbook Book Cover
Apache Maven 3 Cookbook
$ 23.99
$ 12.00
Over 50 recipes towards optimal Java Software Engineering with Maven 3
Java EE 6 Cookbook for Securing, Tuning, and Extending Enterprise Applications Book Cover
Java EE 6 Cookbook for Securing, Tuning, and Extending Enterprise Applications
$ 23.99
$ 12.00
Packed with comprehensive recipes to secure, tune, and extend your Java EE applications with this book and ebook