Mastering phpMyAdmin 3.3.x for Effective MySQL Management -- Table of Contents -- Mastering phpMyAdmin 3.3.x for Effective MySQL Management -- Credits -- About the Author -- About the Reviewers -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 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 -- extension -- connect_type, socket, and port -- compress configuration -- PersistentConnections -- Upgrading phpMyAdmin -- Summary -- 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 -- 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 -- Tree display of database names -- Table name filter -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- Configuring the infrastructure -- 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 -- 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 -- 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.