Mastering phpMyAdmin 3.3.x for Effective MySQL Management


There is a newer version of this book available - Mastering phpMyAdmin 3.4 for Effective MySQL Management
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
eBook: $23.99
Formats: PDF, PacktLib, ePub and Mobi formats
$20.39
save 15%!
Print + free eBook + free PacktLib access to the book: $63.98    Print cover: $39.99
$39.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • The best introduction to phpMyAdmin available
  • Written by the project leader of phpMyAdmin, and improved over several editions
  • A step-by-step tutorial for manipulating data with phpMyAdmin
  • Learn to do things with your MySQL database and phpMyAdmin that you didn't know were possible!

 

Book Details

Language : English
Paperback : 412 pages [ 235mm x 191mm ]
Release Date : October 2010
ISBN : 1849513546
ISBN 13 : 9781849513548
Author(s) : Marc Delisle
Topics and Technologies : All Books, Big Data and Business Intelligence, MySQL, Open Source, PHP


Table of Contents

Preface
Chapter 1: Getting Started with phpMyAdmin
Chapter 2: Configuring Authentication and Security
Chapter 3: Over Viewing the Interface
Chapter 4: Taking First Steps
Chapter 5: Changing Data and Structure
Chapter 6: Exporting Structure and Data (Backup)
Chapter 7: Importing Structure and Data
Chapter 8: Searching Data
Chapter 9: Performing Table and Database Operations
Chapter 10: Benefiting from the Relational System
Chapter 11: Entering SQL Commands
Chapter 12: Generating Multi-table Queries
Chapter 13: Synchronizing Data and Supporting Replication
Chapter 14: Using Bookmarks
Chapter 15: Documenting the System
Chapter 16: Transforming Data Using MIME
Chapter 17: Supporting MySQL 5.0 and 5.1
Chapter 18: Tracking Changes
Chapter 19: Administrating the MySQL Server with phpMyAdmin
Appendix A: The History of phpMyAdmin
Appendix B: Troubleshooting and Support
Index
  • Chapter 1: Getting Started with phpMyAdmin
    • Introducing phpMyAdmin
      • Web applications
      • PHP and MySQL: The leading open source duo
      • What is phpMyAdmin?
        • Project documentation
    • Installing phpMyAdmin
      • Required information
      • System requirements
      • Downloading the files
      • Installing on different platforms
        • Installing on a remote server using a Windows machine
        • Installing on a local Linux server
        • Installing on local Windows servers (Apache, IIS)
    • Configuring phpMyAdmin
      • The config.inc.php file
        • Avoiding false error messages about permissions on config.inc.php
      • Configuration principles
      • Web-based setup script
      • Manually creating config.inc.php
      • Tips for editing config.inc.php on a Windows client
      • Description of some configuration parameters
        • PmaAbsoluteUri
        • Server-specific sections
        • PersistentConnections
    • Upgrading phpMyAdmin
    • Summary
  • Chapter 2: Configuring Authentication and Security
    • Logging in to MySQL through phpMyAdmin
      • Logging in to an account without a password
      • Authenticating a single user with config
        • Testing the MySQL connection
      • Authenticating multiple users
        • Authentication types offered
        • The control user
        • Logging out
        • Authenticating with HTTP
        • Authenticating users with cookie values
        • Authenticating through the signon mode
      • Configuring for multiple server support
        • Defining servers in the configuration file
        • Authenticating through an arbitrary server
    • Securing phpMyAdmin
      • Protecting phpMyAdmin at the directory level
      • Displaying error messages
      • Protecting with IP-based access control
        • Defining rules
        • Order of interpretation for rules
        • Blocking root access
      • Protecting in-transit data
      • Authenticating using Swekey hardware
        • Configuring Swekey authentication
        • Using phpMyAdmin in a Swekey context
        • Security note
      • Access logging
        • Available information
        • Configuring Apache
    • Summary
  • Chapter 3: Over Viewing the Interface
    • Over viewing panels and windows
      • Login panels
      • Navigation and main panels
        • Home page
        • Views
      • Query window
      • Starting page
    • Customizing general settings
      • Configuring the window title
      • Configuring icons
      • Natural sort order for database and table names
      • Creating site-specific headers and footers
      • Displaying MySQL documentation links
      • Themes
        • Configuring themes
        • Selecting themes
      • Assigning colors using the color picker
      • Sliders
      • Limiting URL lengths
      • Restricting the list of databases
    • Character sets, collations, and language
      • Collations
      • Unicode and UTF-8
      • Selecting languages
      • Effective character sets and collations
    • Navigation panel
      • Configuring the logo
      • Database and table list
        • Light mode
        • Full mode
        • Table short statistics
        • Table quick-access icon
        • Nested display of tables within a database
      • Choosing from the server list
      • Handling many databases or tables
        • Limits on the interface
        • Improving fetch speed
    • Main panel
      • Home page
      • Database view
      • Table view
      • Server view
      • Icons for the home page and menu tabs
      • Opening a new phpMyAdmin window
    • Query window
    • Summary
  • Chapter 4: Taking First Steps
    • Creating a database
      • No privileges?
      • First database creation is authorized
    • Creating our first table
      • Choosing the fields
      • Creating a table
      • Choosing keys
    • Inserting data manually
      • Data entry panel tuning for CHAR and VARCHAR
    • Browse mode
      • SQL query links
      • Navigation bar
      • Query results operations
      • Sorting results
        • Headwords
      • Color-marking rows
      • Limiting the length of each column
        • Display options
      • Browsing distinct values
      • Customizing the browse mode
    • Creating an additional table
    • Summary
  • Chapter 5: Changing Data and Structure
    • Changing data
      • Entering edit mode
        • Moving to the next field with the tab key
        • Moving with arrows
        • Handling NULL values
        • Applying a function to a value
        • Duplicating rows of data
      • Multi-row editing
      • Editing the next row
      • Deleting data
        • Deleting a single row
        • Deleting many rows
        • Deleting all of the rows in a table
        • Deleting all rows in many tables
      • Deleting tables
      • Deleting databases
    • Changing a table's structure
      • Adding a field
        • Vertical mode
        • Horizontal mode
      • Editing field attributes
      • TEXT fields
      • BLOB (Binary Large Object) fields
        • Uploading binary content
      • ENUM and SET fields
      • DATE, DATETIME, and TIMESTAMP fields
        • Calendar pop up
        • TIMESTAMP options
      • Bit fields
      • Managing indexes
        • Single-field indexes
        • Multi-field indexes and index editing
        • FULLTEXT indexes
        • Optimizing indexes with EXPLAIN
        • Detecting index problems
    • Summary
  • Chapter 6: Exporting Structure and Data (Backup)
    • Dumps, backups, and exports
      • Scope of the export
    • Exporting a database
      • The export subpanel
      • SQL
        • Defining options for SQL export
      • The "Save as file" subpanel
        • File name template
        • Compression
        • Choosing a character set
        • Kanji support
      • CSV
      • CSV for MS Excel
      • PDF
      • Microsoft Word 2000
      • LaTeX
      • XML
      • Open document spreadsheet
      • Open document text
      • YAML
      • CodeGen
      • Texy! text
      • PHP array
      • Excel 97-2003 and Excel 2007 Workbook
      • MediaWiki table
    • Exporting a table
      • Split-file exports
    • Exporting selectively
      • Exporting partial query results
      • Exporting and checkboxes
    • Exporting multiple databases
    • Saving the export file on the server
      • User-specific save directories
    • Memory limits
    • Summary
  • Chapter 7: Importing Structure and Data
    • Limits for the transfer
      • Time limits
      • Other limits
      • Handling big export files
      • Uploading into a temporary directory
    • Importing SQL files
    • Importing CSV files
      • Differences between SQL and CSV formats
      • Exporting a test file
      • CSV
      • CSV using LOAD DATA
        • Requirements
        • Using the LOAD DATA interface
    • Importing other formats
      • Open Document Spreadsheet
      • Excel
      • XML
    • Reading files from a web server upload directory
    • Displaying an upload progress bar
      • Configuring APC
    • Displaying a character set dialog
    • Summary
  • Chapter 8: Searching Data
    • Using Search page daily
    • Single-table searches
      • Entering the search subpage
      • Searching criteria by field—query by example
        • Searching for empty or non-empty values
      • Producing reports with Print view
      • Searching with wildcard characters
      • Performing a case-sensitive search
      • Combining criteria
      • Search options
        • Selecting the fields to be displayed
        • Ordering the results
        • Applying a WHERE clause
        • Avoiding repeated results
    • Performing a complete database search
      • Restricting the search to a column
      • Stopping an errant query
    • Summary
  • Chapter 9: Performing Table and Database Operations
    • Maintaining a table
    • Changing table attributes
      • Table storage engine
      • Table comments
      • Table order
      • Table collation
      • Table options
    • Renaming, moving, and copying tables
      • Appending data to a table
    • Multi-table operations
      • Repairing an "in use" table
    • Database operations
      • Renaming a database
      • Copying a database
    • Summary
  • Chapter 10: Benefiting from the Relational System
    • Relational MySQL
      • InnoDB and PBXT
    • Linked-tables infrastructure
      • Goal of the infrastructure
      • Location of the infrastructure
      • Installing the linked-tables infrastructure
        • Installing for a single user
        • Installing for multiple users
    • Defining relations with the relation view
      • Defining internal relations
        • Defining the relation
        • Defining the display field
      • Foreign key relations
        • Foreign keys without linked-tables infrastructure
    • Defining relations with the Designer
      • Over viewing the interface
      • Defining relations
        • Defining foreign key relations
      • Defining the display field
      • Exporting for PDF schema
    • Benefiting from the defined relations
      • Foreign key information
      • The drop-down list of foreign keys
      • The browsable foreign-table window
      • Referential integrity checks
      • Automatic updates of metadata
    • Column-commenting
      • Automatically migrating column comments
    • Summary
  • Chapter 11: Entering SQL Commands
    • The SQL query box
      • The Database view
      • The Table view
        • The Fields selector
        • Clicking into the query box
    • The Query window
      • Query window options
      • Session-based SQL history
      • Database-based SQL history (permanent)
      • Editing queries in the query window
    • Multi-statement queries
    • Pretty printing (syntax-highlighting)
    • The SQL Validator
      • System requirements
      • Making the Validator available
      • Validator results
        • Standard-conforming queries
        • Non-standard-conforming queries
    • Summary
  • Chapter 12: Generating Multi-table Queries
    • Choosing tables
    • Exploring column criteria
      • Field selector: Single-column or all columns
      • Sorting columns
      • Showing a column
      • Updating the query
      • Adding conditions to the criteria box
        • Adjusting the number of criteria rows
        • Adjusting the number of criteria columns
    • Generating automatic joins
    • Executing the query
    • Summary
  • Chapter 13: Synchronizing Data and Supporting Replication
    • Synchronizing data and structure
      • Goals of synchronization
        • Moving between the development and production servers
        • Collaboration between database designers
        • Preparing for replication
      • Over viewing the synchronization process
      • Preparing for the synchronization exercise
      • Choosing source and target servers and databases
      • Analyzing comparison results
      • Performing a complete synchronization
      • Performing a selective synchronization
    • Supporting MySQL replication
      • The Replication menu
      • Configuring replication
        • Master server configuration
        • Slave server configuration
      • Setting up a test environment
      • Controlling a slave server
      • Obtaining replication information
        • Gathering replication status
        • Replicated databases
        • Replicated tables
    • Summary
  • Chapter 14: Using Bookmarks
    • Comparing bookmark and query history features
    • Creating bookmarks
      • Creating a bookmark after a successful query
      • Storing a bookmark before sending a query
      • Making bookmarks public
      • The default initial query for a table
      • Multi-query bookmarks
    • Recalling bookmarks from the bookmarks list
      • Executing bookmarks
      • Manipulating bookmarks
    • Bookmark parameters
      • Creating a parameterized bookmark
      • Passing a parameter value to a bookmark
    • Executing bookmarks by browsing the pma_bookmark table
    • Summary
  • Chapter 15: Documenting the System
    • Producing structure reports
      • Creating a printable report
      • The database print view
        • The selective database print view
      • The table print view
      • Preparing a complete report with the data dictionary
    • Generating relational schemas in PDF
      • Adding a third table to our model
      • Editing PDF pages
        • Page planning
        • Creating a new page
        • Editing a page
        • Displaying a page
        • Changing the font in PDF schema
      • Laying out a PDF schema with the Designer feature
    • Summary
  • Chapter 16: Transforming Data Using MIME
    • Browsing data without transformations
      • Switching display options
    • Enabling transformations
      • Configuring settings for MIME columns
        • Selecting the MIME type
        • Browser transformations
        • Assigning values to transformation options
      • Requirements for image generation
        • Configuring GD2 library availability verification
        • Asserting support of JPEG and PNG libraries
        • Evaluating the impact of memory limits
    • Examples of transformations
      • Clickable thumbnail (.jpeg or .png)
      • Adding links to an image
      • Date formatting
      • Links from text
        • text/plain: link
        • text/plain: imagelink
      • Preserving the original formatting
      • Displaying parts of a text
      • Displaying a download link
      • Hexadecimal representation
      • SQL pretty printing
      • IP address
      • Transforming data via external applications
        • External application example: In-cell sort
    • Summary
  • Chapter 17: Supporting MySQL 5.0 and 5.1
    • Activating support for views
      • Manually creating a view
      • Main panel and views
      • Creating a view from results
      • Renaming a view
      • Controlling row counting for improved performance
    • Supporting routines—stored procedures and functions
      • Creating a stored procedure
        • Changing the delimiter
        • Entering the procedure
      • Testing the procedure
      • Manipulating procedures and functions
      • Manually creating a function
      • Testing the function
      • Exporting stored procedures and functions
    • Executing code with triggers
      • Manually creating a trigger
      • Testing the trigger
    • Using information_schema
    • Profiling
    • Partitioning
      • Creating a table with partitions
      • Maintaining partitions
      • Exporting a partition definition
    • Exploring the Event Scheduler
      • Activating the scheduler
      • Granting EVENT permission
      • Creating an event
      • Manipulating events
      • Exporting
    • BLOB streaming
      • System requirements
      • Configuring BLOB streaming
      • Examining implementation limitations in phpMyAdmin
      • Creating the PBMS system tables
      • Preparing the table
      • Uploading to the BLOB repository
      • Streaming the data from the repository
      • Changing repository data
    • Summary
  • Chapter 18: Tracking Changes
    • Understanding the goals of the tracking system
      • Tracking in other software applications
      • Tracking in phpMyAdmin
    • Prerequisites
      • Configuring a basic tracking mechanism
    • Principles
      • Versioning
      • Taking a snapshot of the current structure
      • Understanding archiving issues
    • Initiating tracking for one table
      • Choosing the statements to be tracked
    • Testing the tracking mechanism
      • Tracking report
    • Determining tracking status
      • Deactivating and activating tracking
    • Structure snapshot
    • Exporting a version
    • Creating a new version
      • Quickly accessing tracking information
    • Deleting tracking information
    • Summary
  • Chapter 19: Administrating the MySQL Server with phpMyAdmin
    • Managing users and their privileges
      • The user overview
        • Privileges reload
      • Adding a user
        • Entering the username
        • Assigning a host value
        • Setting passwords
        • Understanding rights for database creation
        • Assigning global privileges
        • Limiting the resources used
      • Editing a user profile
        • Editing privileges
        • Assigning database-specific privileges
        • Changing the password
        • Changing login information or copying a user
      • Removing a user
    • Database information
      • Enabling statistics
      • Sorting statistics
      • Checking the database privileges
      • Dropping selected databases
    • Server information
      • Verifying server status
        • The general status page
        • InnoDB status
      • Server variables
      • Server processes
      • Storage engines
      • Available character sets and collations
      • Examining binary logs
    • Summary
  • Appendix B: Troubleshooting and Support
    • System requirements
    • Verifying the base configuration
    • Solving common errors
      • Troubleshooting error messages
        • Cannot load MySQL extension
        • #2003 - Can't connect to MySQL server
        • Socket problem (Linux/UNIX)
        • Named pipe problem (Windows)
        • MySQL said: Access denied
        • When using http authentication
        • When using http, cookie, or config authentication
        • Access denied ... "using password: NO"
        • Access denied ... "using password: YES"
        • Login without a password is forbidden by configuration
        • Warning: cannot add header information
        • MySQL said: Error 127, Table Must Be Repaired
        • BLOB column used in key specification without a key length
        • IIS: No Input File Specified
        • A "404: page not found" error when modifying a row
      • Troubleshooting other problems
        • Blank page or weird characters
        • Not being able to create a database
        • Problems importing large files or uploading large BLOB files
        • MySQL root password lost
        • Duplicate field names when creating a table
        • Authentication window displayed more than once
        • Column size changed by phpMyAdmin
        • Seeing many databases that are not ours
        • Not being able to store a value greater than 127
    • Seeking support
    • FAQs
    • Help forums
      • Creating a SourceForge account
      • Choosing the thread title
      • Reading the answers
      • Using the support tracker
      • Using the bug tracker
      • Environment description
      • Bug description
    • Contributing to the project
      • The code base
      • Translation updates
      • Patches

Marc Delisle

Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin. He started to contribute to the project in December 1998, when he made the multi-language version. He is still involved with phpMyAdmin as a developer and project administrator. Marc is a system administrator at Cegep de Sherbrooke, Québec, Canada. He has been teaching networking, security, and web 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.
Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


Errata

- 1 submitted: last submission 07 Feb 2012

Errata type: Others | Page number: 2 | Errata date: 04 Sep 08

when selecting this book from from your Drop Down List: It should mention:- "Published Oct 2010

 

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Mastering phpMyAdmin 3.3.x for Effective MySQL Management +    Plone 3 Multimedia =
50% Off
the second eBook
Price for both: £19.40

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Upload phpMyAdmin to your web server and upgrade to the latest version
  • Manage multiple servers using a single copy of phpMyAdmin
  • Protect authentication credentials according to the needs of a users' group and secure your phpMyAdmin installation using the various available authentication types
  • Export a table's structure and data for backup purposes and also use it as a gateway to another application
  • Import back a table's structure and data, provided the chosen format is supported by phpMyAdmin
  • Search for entries in a single-table by specifying the search criteria and also perform a search in the whole database
  • Define inter-table relations in a relational system and install the linked-tables infrastructure for keeping special metadata
  • Enter your own SQL queries into phpMyAdmin to perform actions that are beyond the scope of the interface and keep a history of these queries
  • Produce and maintain good documentation that explains the structure of your databases using the tools offered by phpMyAdmin
  • Apply transformations to data, in order to customize its format at view time
  • Administer a MySQL server by managing user accounts and privileges
  • Troubleshoot some common problems encountered in phpMyAdmin and prevent some of these problems from reoccurring
  • Save time while retrieving queries by storing them as bookmarks

 

In Detail

phpMyAdmin is an open source tool written in PHP to handle MySQL administration over the World Wide Web. It can execute SQL statements and manage users and their permissions. However, when it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators are left baffled.

Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy-to-follow, step-by-step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutorial approach to take full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.

The book helps you get started with installing and configuring phpMyAdmin and looks at its features. You then work on a sample project with two basic tables and perform basic actions such as creating, editing, and deleting data, tables, and databases. You will learn how to create up-to-date backups and import the data that you have exported. You will then explore different search mechanisms and options for querying across multiple tables.

The book gradually proceeds to advanced features such as defining inter-table relations and installing the linked-tables infrastructure. Some queries are out of the scope of the interface and this book will show you how to accomplish these tasks with SQL commands.

New features of version 3.3.x, such as synchronizing databases on different servers and managing MySQL replication to improve performance and data security, are covered in this book. Towards the end of the book you will learn to document your database, track changes made to the database, and manage user accounts using phpMyAdmin server management features.

This book is an upgrade from the previous version that covered phpMyAdmin Version 3.1. Version 3.3.x introduced features such as new import and export modules, tracking changes, synchronizing structure and data between servers, and providing support for replication.

A complete guide to get started with phpMyAdmin 3.3 and master its features by implementing them on your database to your advantage

Approach

This is a step-by-step instructional guide to get you started easily with phpMyAdmin and teach you to manage and perform database functions on your database. You will first be introduced to the interface and then build basic tables and perform both simple and advanced functions on the created database. The book progresses gradually and you will follow it best by reading it sequentially.

Who this book is for

If you are a developer or system administrator or web designer who wants to manage MySQL databases and tables efficiently, this book is for you. This book assumes you already are well acquainted with MySQL basics. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software