Mastering Phpmyadmin 3.3.X For Effective Mysql Management

This step-by-step instructional guide for developers, system administrators or web designers is a must-read for every serious phpMyAdmin user wanting to use its full power. Readers should already be well acquainted with MySQL basics. The book starts with installing and configuring phpMyAdmin and introduces its interface. You then perform basic actions: creating, editing, and deleting data, tables, and databases. You learn to create backups and re-import the data you have exported then explore search mechanisms and options for querying across multiple tables, gradually proceeding to more advanced features: defining inter-table relations, installing the linked-tables infrastructure, using SQL commands to accomplish queries beyond the scope of the interface, documenting databases, tracking database changes, managing user accounts, and new features of version 3.3.x, such as synchronizing databases on different servers and managing MySQL replication to improve performance and data security.