Mastering phpMyAdmin 3.3.x for Effective MySQL Management
A complete guide to get started with phpMyAdmin 3.3 and master its features
Published on 13. January 2025
412 pages
978-1-84951-355-5 (ISBN)
Description
A complete guide to get started with phpMyAdmin 3.3 and master its features
Key Features
The best introduction to phpMyAdmin available
Written by the project leader of phpMyAdmin, and improved over several editions
A step-by-step tutorial for manipulating data with phpMyAdmin
Learn to do things with your MySQL database and phpMyAdmin that you didn't know were possible!
Book DescriptionphpMyAdmin 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.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
Who this book is forIf you are a developer or system administrator or web designer who wants to manage MySQL databases and tables efficiently, this book is for you. This book assumes you already are well acquainted with MySQL basics. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.
Key Features
The best introduction to phpMyAdmin available
Written by the project leader of phpMyAdmin, and improved over several editions
A step-by-step tutorial for manipulating data with phpMyAdmin
Learn to do things with your MySQL database and phpMyAdmin that you didn't know were possible!
Book DescriptionphpMyAdmin 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.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
Who this book is forIf you are a developer or system administrator or web designer who wants to manage MySQL databases and tables efficiently, this book is for you. This book assumes you already are well acquainted with MySQL basics. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.
All prices
More details
Edition
Digital original
Language
English
Place of publication
Birmingham
United Kingdom
Edition type
Digital original
File size
16,61 MB
ISBN-13
978-1-84951-355-5 (9781849513555)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Book
10/2010
Packt Publishing
€52.00
Shipment within 3-4 weeks
Person
Marc Delisle was awarded "MySQL Community Member of the year 2009" because of his involvement with phpMyAdmin. He started to contribute to the project in December 1998, when he made the multi-language version. He is still involved with phpMyAdmin as a developer and project administrator. Marc is a system administrator at Cegep de Sherbrooke, Qubec, Canada. He has been teaching networking, security, and web application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina. Marc lives in Sherbrooke with his wife and they enjoy spending time with their four children.
Content
Table of Contents
