Mastering phpMyAdmin 3.3.x for Effective MySQL Management

A complete guide to get started with phpMyAdmin 3.3 and master its features

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Marc Delisle

A complete guide to get started with phpMyAdmin 3.3 and master its features
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $23.99
Save 58%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$39.99
$29.99 p/m after trial
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Mastering phpMyAdmin 3.3.x for Effective MySQL Management Book Cover
Mastering phpMyAdmin 3.3.x for Effective MySQL Management
$ 23.99
$ 10.00
Mastering phpMyAdmin 3.4 for Effective MySQL Management Book Cover
Mastering phpMyAdmin 3.4 for Effective MySQL Management
$ 23.99
$ 10.00
Buy 2 for $20.00
Save $27.98
Add to Cart

Book Details

ISBN 139781849513548
Paperback412 pages

Book Description

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

Chapter 2: Configuring Authentication and Security
Chapter 5: Changing Data and Structure
Chapter 13: Synchronizing Data and Supporting Replication

What You Will Learn

  • Upload phpMyAdmin to your web server and upgrade to the latest version
  • Manage multiple servers using a single copy of phpMyAdmin
  • Protect authentication credentials according to the needs of a users' group and secure your phpMyAdmin installation using the various available authentication types
  • Export a table's structure and data for backup purposes and also use it as a gateway to another application
  • Import back a table's structure and data, provided the chosen format is supported by phpMyAdmin
  • Search for entries in a single-table by specifying the search criteria and also perform a search in the whole database
  • Define inter-table relations in a relational system and install the linked-tables infrastructure for keeping special metadata
  • Enter your own SQL queries into phpMyAdmin to perform actions that are beyond the scope of the interface and keep a history of these queries
  • Produce and maintain good documentation that explains the structure of your databases using the tools offered by phpMyAdmin
  • Apply transformations to data, in order to customize its format at view time
  • Administer a MySQL server by managing user accounts and privileges
  • Troubleshoot some common problems encountered in phpMyAdmin and prevent some of these problems from reoccurring
  • Save time while retrieving queries by storing them as bookmarks

 

Authors

Table of Contents

Chapter 2: Configuring Authentication and Security
Chapter 5: Changing Data and Structure
Chapter 13: Synchronizing Data and Supporting Replication

Book Details

ISBN 139781849513548
Paperback412 pages
Read More

Read More Reviews

Recommended for You

Mastering phpMyAdmin 3.4 for Effective MySQL Management Book Cover
Mastering phpMyAdmin 3.4 for Effective MySQL Management
$ 23.99
$ 10.00
phpMyAdmin Starter Book Cover
phpMyAdmin Starter
$ 12.99
$ 9.10
Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
Mastering phpMyAdmin for Effective MySQL Management  Book Cover
Mastering phpMyAdmin for Effective MySQL Management
$ 23.99
$ 10.00
MySQL Admin Cookbook LITE: Replication and Indexing Book Cover
MySQL Admin Cookbook LITE: Replication and Indexing
$ 9.99
$ 7.00
Advanced Penetration Testing for Highly-Secured Environments: The Ultimate Security Guide Book Cover
Advanced Penetration Testing for Highly-Secured Environments: The Ultimate Security Guide
$ 35.99
$ 7.20