|
Mastering phpMyAdmin 2.11 for Effective MySQL Management
PhpMyAdmin is a well known and popular open-source tool written in PHP intended to handle the administration of MySQL over the Internet. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, and manage keys on fields. While most MySQL developers use routine features of phpMyAdmin every
day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool.
MySQL is the most popular open-source database, used by millions of developers and supporting numerous large dynamic websites and applications. MySQL acquired this wide popularity by virtue of its open-source nature, performance, reliability, robustness, and support for various platforms. This popularity has also been helped by the existence of phpMyAdmin, the industry-standard administration tool that makes database management easy for both the experienced developer and the novice.
The powerful graphical interface that it provides to MySQL has made phpMyAdmin an indispensable tool for MySQL and web developers. Every phpMyAdmin user can benefit from unlocking the full potential of this powerful application. Whether you are an experienced developer, system administrator, web designer, or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your databases.
What you will learn from this book
* Common reasons for installing PhpMyAdmin
* Managing multiple servers on single copy of PhpMyAdmin
* Securing your PhpMyAdmin installation
* Upgrading your PhpMyAdmin installation
* Managing databases, data table structures, and indexes to create efficient databases
* Administering MySQL users and privileges
* Getting server and database statistics
* Generating better documentation of evolving table structures
CONTENTS:
Chapter1,Introducing phpMyAdmin
Chapter2,Installing phpMyAdmin
Chapter3,Interface Overview
Chapter4,First Steps
Chapter5,Changing Data
Chapter6,Changing Table Structures
Chapter7,Exporting Structure and Data
Chapter8,Importing Structure and Data
Chapter9,Searching Data
Chapter10,Table and Database Operations
Chapter11,The Relational System
Chapter12,Entering SQL Demands
Chapter13,The Multi-Table Query Generator
Chapter14,Boomarks
Chapter15,System Documentation
Chapter16,MIME-Based Transformations
Chapter17,Character Sets and Collations
Chapter18 MySQL 5.0 Features
Chapter19,MySQL Server Administration
Chapter20,Troubleshooting and Support
Index
|
