Mastering phpMyAdmin 3.4 for Effective MySQL Management
Getting Started with phpMyAdmin
PHP and MySQL: The leading open source duo
Installing phpMyAdmin configuration storage
Configuring Authentication and Security
Logging in to MySQL through phpMyAdmin
Over viewing panels and windows
Exporting Structure and Data (Backup)
Saving the export file on the server
Reading files from a web server upload directory
Displaying an upload progress bar
Performing a complete database search
Performing Table and Database Operations
Renaming, moving, and copying tables
Performing other table operations
Benefiting from the Relational System
Defining relations with the relation view
Defining relations with the Designer
Benefiting from the defined relations
Pretty printing (syntax highlighting)
Generating Multi-table Queries
Generating automatic joins (internal relations)
Synchronizing Data and Supporting Replication
Synchronizing data and structure
Comparing bookmark and query history features
Recalling bookmarks from the bookmarks list
Passing a parameter to a bookmark
Browsing data without transformations
Supporting Features Added in MySQL 5
Supporting routines—stored procedures and functions
Understanding the goals of the tracking system
Initiating tracking for one table
Testing the tracking mechanism
Administrating the MySQL Server