Get Mastering phpMyAdmin 3. Explore a preview version of Mastering phpMyAdmin 3. Mastering phpMyAdmin 3. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail. This is the official guide to this popular MySQL web interface.
|Published (Last):||5 September 2007|
|PDF File Size:||9.85 Mb|
|ePub File Size:||19.96 Mb|
|Price:||Free* [*Free Regsitration Required]|
By Marc Delisle. All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied.
Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals.
However, Packt Publishing cannot guarantee the accuracy of this information. He started to contribute to the project in December , when he made the multi-language version. He is involved with phpMyAdmin as a developer, translator, and project administrator and enjoys meeting phpMyAdmin users in person. He lives in Sherbrooke with his wife and they enjoy spending time with their four children.
I am truly grateful to the Packt team whose sound comments were greatly appreciated during the production. My thanks also go to the reviewers of all editions; their sharp eyes helped in making this book clearer and more complete. Finally, I wish to thank all contributors to phpMyAdmin's source code, translations, and documentation; their dedication to this project continues to push me forward.
Currently he works as a software engineer and is located in Colombo, Sri Lanka. He is a member of phpMyAdmin team and has contributed with GIS support for the software, which will be a part of its future releases. He continues to contribute by coding and translating the software. Born in Saint Petersbourg in , his enthusiasm for programming and electronics was nurtured from a very early age.
He is passionate about high performance and secure software and has been contributing to open source software with phpMyAdmin and Geeklog. During the summer of he took part in the Google Summer of Code program, where he developed an improved interface for MySQL routines, triggers, and events for phpMyAdmin.
He currently also teaches Math and programming to second and third-level students. You might want to visit www. You can upgrade to the eBook version at www. Get in touch with us at for more details. At www.
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books. If you have an account with Packt at www.
Simply use your login credentials for immediate access. It can perform various tasks such as creating, modifying, or deleting databases, tables, columns, or rows. It can also execute SQL statements or manage users and their permissions. When it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators search for tutorials to accomplish their tasks.
Mastering phpMyAdmin 3. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail. This book jump starts with installing and configuring phpMyAdmin, and then looks into phpMyAdmin's features. This is followed by configuring authentication in phpMyAdmin and setting parameters that influence the interface as a whole, including the new user preferences feature.
You will first create two basic tables and then edit, delete data, tables, and databases. As backups are crucial to a project, you will create up-to-date backups and then look into importing the data that you have exported. You will also explore the various search mechanisms and query across multiple tables.
Now you will learn some advanced features such as defining inter-table relations, both with relation view and the Designer panel. Some queries are out of the scope of the interface; you will enter SQL command to accomplish these tasks. You will also learn about synchronizing databases on different servers and managing MySQL replication to improve performance and data security. You will also store queries as bookmarks for their quick retrieval.
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.
Version 3. It then covers the downloading and installation procedures for phpMyAdmin. Installing the phpMyAdmin configuration storage is covered as well. Chapter 2, Configuring Authentication and Security , provides an overview of various authentication types used in phpMyAdmin.
It then covers the security issues related to phpMyAdmin. It includes the login panel, the navigation and main panels with the Light and the Full mode, and the Query window. The new user preferences module is examined in this chapter. Chapter 4, Creating and Browsing Tables , is all about database creation. It teaches us how to create a table, how to insert data manually, and how to sort the data. It also covers how to produce charts from data. It teaches us handling NULL values, multi-row editing, and data deletion.
Chapter 6, Exporting Structure and Data Backup , deals with backups and exports. It lists various ways to trigger an export, available export formats, the options associated with export formats, and the various places where the export files may be sent. Chapter 7, Importing Structure and Data , tells us how to bring back exported data created for backup and transfer purposes. It covers the various options available in phpMyAdmin to import data, and different mechanisms involved in importing SQL files, CSV files, and other formats.
Finally, it covers the limitations that may be faced while importing files, and the ways to overcome them. Chapter 8, Searching Data , presents the mechanisms that are useful for searching data effectively, per table or inside an entire database. Chapter 9, Performing Table and Database Operations , covers ways to perform some operations that influence and can be applied on entire tables or databases as a whole.
Finally, it deals with table maintenance operations for table repair and optimization. Chapter 10, Benefiting from the Relational System , is where we start covering advanced features of phpMyAdmin.
The chapter explains how to define inter-table relations and how these relations can help us while browsing tables, entering data, or searching for it. The chapter also covers the Query window—the window used to edit an SQL query. Finally, it also helps us to obtain the history of typed commands. Chapter 12, Generating Multi-table Queries , covers the multi-table query generator, which allows us to produces these queries without actually typing them.
The visual query builder is covered as well. Chapter 13, Synchronizing Data and Supporting Replication , teaches us how to synchronize databases on the same server or from one server to another.
It then covers how to manage MySQL replication. Chapter 14, Using Query Bookmarks , covers one of the features of the phpMyAdmin configuration storage. It shows how to record bookmarks and how to manipulate them. Finally, it covers passing parameters to bookmarks. Chapter 15, Documenting the System , gives an overview of how to produce documentation which explains the structure of the databases, using the tools offered by phpMyAdmin.
Chapter 16, Transforming Data Using MIME , explains how to apply transformations to the data in order to customize its format at view time. Chapter 18, Tracking Changes , teaches us how to record structure and data changes done from the phpMyAdmin interface. The chapter discusses how a system administrator can use phpMyAdmin's server management features for day-to-day user account maintenance, server verification, and server protection.
Appendix, Troubleshooting and Support , explains how to troubleshoot phpMyAdmin by performing simple verifications. It also explains how to interact with the development team for support, bug reports, and contributions. You need to have access to a server or workstation that has the following installed:.
If you are a developer, system administrator, or web designer who wants to manage MySQL databases and tables efficiently, then this book is for you.
This book assumes that you are already 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. In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.
Code words in text are shown as follows: If this information is not available, a good alternate choice is localhost. When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:. New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: There are various files available in the Download section.
Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of. Upload Sign In Join. Home Books Technology.
Create a List. Download to App.
Mastering phpMyAdmin 3.4 for Effective MySQL Management
Goodreads helps you keep track of books you want to read. Want to Read saving…. Want to Read Currently Reading Read. Other editions. Enlarge cover. Error rating book.
Mastering Phpmyadmin 3.4 for Effective MySQL Management