Book Image

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Book Image

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Overview of this book

phpMyAdmin is an open source tool written in PHP to handle MySQL administration over the World Wide Web. It can execute SQL statements and manage users and their permissions. However, when it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators are left baffled.Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy-to-follow, step-by-step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutorial approach to take full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.The book helps you get started with installing and configuring phpMyAdmin and looks at its features. You then work on a sample project with two basic tables and perform basic actions such as creating, editing, and deleting data, tables, and databases. You will learn how to create up-to-date backups and import the data that you have exported. You will then explore different search mechanisms and options for querying across multiple tables.The book gradually proceeds to advanced features such as defining inter-table relations and installing the linked-tables infrastructure. Some queries are out of the scope of the interface and this book will show you how to accomplish these tasks with SQL commands.New features of version 3.3.x, such as synchronizing databases on different servers and managing MySQL replication to improve performance and data security, are covered in this book. Towards the end of the book you will learn to document your database, track changes made to the database, and manage user accounts using phpMyAdmin server management features.This book is an upgrade from the previous version that covered phpMyAdmin Version 3.1. Version 3.3.x introduced features such as new import and export modules, tracking changes, synchronizing structure and data between servers, and providing support for replication.
Table of Contents (26 chapters)
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Appendix B. Troubleshooting and Support

This appendix proposes guidelines for solving some common problems, and provides hints on how to avoid them. It also explains how to interact with the development team for support, bug reports, and contributions.

System requirements

A section at the beginning of the Documentation.html file (which is included with phpMyAdmin's software), discusses system requirements for the particular phpMyAdmin version we are using. It's crucial that these requirements be met, and that the environment be properly configured, so that problems are avoided.

Some problems, such as phpMyAdmin bugs, are in fact caused by the server environment. Sometimes, the web server is not configured to interpret .php files correctly, or the PHP component inside the web server does not run with the mysql or mysqli extensions. MySQL accounts may be badly configured. This can happen on home servers as well as on hosted servers.

When we suspect that something is wrong, we can try a simple PHP script, test.php, which contains the following, to check if the PHP component answers correctly:

<?php
echo 'hello';
?>

We should see the hello message. If this works, we can try another script:

<?php
phpinfo();
?>

This script displays information about the PHP component, including the available extensions. We should at least see a section about MySQL (proving that the mysql or mysqli extension is available), which provides information about the MySQL Client API version.

We can also try other PHP scripts that make a connection to MySQL, to see if the problem is more general than just phpMyAdmin not working. As a general rule, we should be running the latest stable versions of every component.