Mastering phpMyAdmin 3.4 for Effective MySQL Management -- Table of Contents -- Mastering phpMyAdmin 3.4 for Effective MySQL Management -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers, and more -- Why Subscribe? -- Free Access for Packt account holders -- 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 -- 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 client -- Installing on a local Linux server -- Installing on a local Windows server (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 -- PersistentConnections -- controluser -- Installing phpMyAdmin configuration storage -- Goal of the configuration storage -- Location of the configuration storage -- Performing the installation -- Installing for a single user -- Installing for multiple users -- 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.

Authenticating with HTTP -- Authenticating with cookie values -- Authenticating with signon mode -- Configuring for multiple server support -- Defining servers in the configuration file -- Authenticating through an arbitrary server -- Logging out -- Securing phpMyAdmin -- Protecting phpMyAdmin at 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 -- 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 window title -- Natural sort order for database and table names -- Creating site-specific header and footer -- Themes -- Configuring themes -- Selecting themes -- Selecting a language -- Slider -- Restricting the list of databases -- Deactivating Ajax -- Character sets and collations -- 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 abridged statistics -- Table quick-access icon -- Nested display of tables within a database -- Counting the number of tables -- 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 home page and menu tabs -- Opening a new phpMyAdmin window -- User preferences -- Accessing user preferences -- Possible locations for saving preferences -- Saving in phpMyAdmin configuration storage -- Saving in a file -- Saving in the browser's local storage -- Changing settings -- Disallowing specific preferences.

Showing developer settings -- Query window -- Summary -- 4. Creating and Browsing Tables -- Creating a database -- No privileges -- First database creation is authorized -- Creating our first table -- Choosing the columns -- 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 -- Displaying data as a chart -- Sorting results -- Headwords -- Color-marking rows or columns -- Limiting the length of each column -- Display options -- Browsing distinct values -- Profiling queries -- Creating an additional table -- Summary -- 5. Changing Data and Structure -- Changing data -- Entering edit mode -- Moving to 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 -- Inline row editing -- Deleting data -- Deleting a single row -- Deleting multiple rows -- Deleting all of the rows in a table -- Deleting all rows in multiple tables -- Deleting tables -- Deleting databases -- Changing table structure -- Adding a column -- Vertical mode -- Editing column attribute -- TEXT column type -- BLOB (Binary Large Object) column type -- Uploading binary content -- ENUM and SET column types -- DATE, DATETIME, and TIMESTAMP column types -- Calendar pop up -- TIMESTAMP option -- Bit column type -- Managing indexes -- Single-column indexes -- Multi-column 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 Table(s) sub-panel -- The Output sub-panel -- File name template -- Choosing a character set -- Kanji support.

Compression -- Export formats -- SQL -- CSV -- CSV for Microsoft Excel -- PDF -- Microsoft Word 2000 -- LaTeX -- XML -- Open document spreadsheet -- Open document text -- YAML -- CodeGen -- Texy! text -- PHP array -- MediaWiki table -- JSON -- 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 -- XML -- Reading files from a web server upload directory -- Displaying an upload progress bar -- Configuring APC -- Summary -- 8. Searching Data -- Single-table searches -- Entering the search page -- Searching criteria by column-query by example -- Searching for empty / non-empty values -- Producing reports with Print view -- Searching with wildcard characters -- Case sensitivity and search -- Combining criteria -- Search options -- Selecting the columns to be displayed -- Ordering the results -- Applying a WHERE clause -- Avoiding repeated results -- Performing a complete database search -- Restricting 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 -- Emptying or deleting a table -- Renaming, moving, and copying tables -- Appending data to a table.

Performing other table operations -- 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 -- Defining relations with the relation view -- Defining internal relations -- Defining the relation -- Defining the display column -- Foreign key relations -- Foreign keys without phpMyAdmin configuration storage -- Defining relations with the Designer -- Over viewing the interface -- Defining relations -- Defining foreign key relations -- Defining the display column -- Exporting for PDF schema -- Benefiting from the defined relations -- Foreign key information -- The drop-down list of foreign keys -- The browseable foreign-table window -- Referential integrity checks -- Automatic updates of metadata -- Column commenting -- Automatically migrating column comments -- Summary -- 11. Entering SQL Statements -- The SQL query box -- The Database view -- The Table view -- The Columns selector -- Clicking into the query box -- The Query window -- Query window options -- Session-based SQL history -- Database-based SQL history (permanent) -- Editing queries -- 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 -- Column 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 (internal relations) -- Executing the query -- The visual builder.

Summary.