Mastering phpMyAdmin 2.11 for Effective MySQL Management

Go down

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Post by KoOL on Mon Mar 24, 2008 10:29 pm







Book Details
Language English
Release date March 2008
ISBN 1847194184
ISBN 13 978-1-847194-18-3
Author(s) Marc Delisle
Topics and Technologies PHP/MySQL

This
book is an upgrade from the previous version that covered phpMyAdmin
Version 2.8. Version 2.10 introduced a new GUI for relations, called
Designer, and version 2.11 adds support for creating Views from query
results, manages triggers, procedures and functions and has an improved
interface for servers handling large number of databases/tables.

In Detail
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
Along the way you will build a more detailed understanding of SQL and how it works in MySQL.

Approach
This
book is a tutorial that systematically explains and demonstrates the
potential of this tool. It then goes on to show the less well known and
generally under-used features and capabilities of phpMyAdmin in depth.

Who this book is written for
Whether
you are an experienced developer, system administrator, web designer or
new to MySQL, phpMyAdmin is a must-have tool for anyone who needs to
manage MySQL databases and tables. This book is a must-read for every
serious phpMyAdmin user who would like to use this outstanding
application to its full power.

more info @http://www.packtpub.com/phpmyadmin-3rd-edition/book
Download: | Rapidshare | DepositFiles |

KoOL
R|F Super Moderator
R|F Super Moderator

Number of posts : 84
Age : 37
Location : India
Points :
85 / 10085 / 100

Registration date : 2008-03-24

View user profile http://www.aioforum.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum