Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering phpMyAdmin 2.11 for Effective MySQL Management
  • Table Of Contents Toc
Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering phpMyAdmin 2.11 for Effective MySQL Management - Third Edition

Buy this Book
close
close
Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Buy this Book

Overview of this book

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.
Table of Contents (25 chapters)
close
close
close
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Icon
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
Preface
Icon
Preface
Lock Free Chapter
1
Introducing phpMyAdmin
chevron up
Icon
Introducing phpMyAdmin
Icon
PHP and MySQL: The Leading Open-Source Duo
Icon
What is phpMyAdmin?
Icon
History
Icon
Awards
Icon
phpMyAdmin Features Summary
Icon
Summary
2
Installing phpMyAdmin
Icon
Installing phpMyAdmin
Icon
System Requirements
Icon
Downloading the Files
Icon
Installation
Icon
First Connection Configuration
Icon
Multi-Server Configuration
Icon
Advanced Authentication
Icon
Security
Icon
Upgrading phpMyAdmin
Icon
Summary
3
Interface Overview
Icon
Interface Overview
Icon
Panels and Windows
Icon
Language Selection
Icon
Themes
Icon
Left Panel
Icon
Right Panel
Icon
Query Window
Icon
Site-Specific Header and Footer
Icon
MySQL Documentation Links
Icon
Summary
4
First Steps
Icon
First Steps
Icon
Database Creation
Icon
Creating Our First Table
Icon
Manual Data Insertion
Icon
Browse Mode
Icon
Creating an Additional Table
Icon
Summary
5
Changing Data
Icon
Changing Data
Icon
Edit Mode
Icon
Multi-Row Editing
Icon
Editing the Next Row
Icon
Deleting Data
Icon
Deleting Tables
Icon
Deleting Databases
Icon
Summary
6
Changing Table Structures
Icon
Changing Table Structures
Icon
Adding a Field
Icon
Editing Field Attributes
Icon
TEXT
Icon
BLOB (Binary Large Object) Fields
Icon
ENUM and SET
Icon
DATE, DATETIME, and TIMESTAMP
Icon
Bit
Icon
Index Management
Icon
Summary
7
Exporting Structure and Data
Icon
Exporting Structure and Data
Icon
Dumps, Backups, and Exports
Icon
Database Exports
Icon
Table Exports
Icon
Selective Exports
Icon
Multi-Database Exports
Icon
Saving the Export File on the Server
Icon
Memory Limits
Icon
Summary
8
Importing Structure and Data
Icon
Importing Structure and Data
Icon
Limits for the Transfer
Icon
Importing SQL Files
Icon
Importing CSV Files
Icon
Web Server Upload Directories
Icon
Summary
9
Searching Data
Icon
Searching Data
Icon
Single-Table Searches
Icon
Complete Database Search
Icon
Summary
10
Table and Database Operations
Icon
Table and Database Operations
Icon
Table Maintenance
Icon
Changing Table Attributes
Icon
Renaming, Moving, and Copying Tables
Icon
Multi-Table Operations
Icon
Database Operations
Icon
Summary
11
The Relational System
Icon
The Relational System
Icon
Relational MySQL?
Icon
Linked-Tables Infrastructure
Icon
Defining Relations with the Relation View
Icon
Defining Relations with the Designer
Icon
Benefits of the Defined Relations
Icon
Column-Commenting
Icon
Summary
12
Entering SQL Commands
Icon
Entering SQL Commands
Icon
The SQL Query Box
Icon
The Query Window
Icon
Multi-Statement Queries
Icon
Pretty Printing (Syntax-Highlighting)
Icon
The SQL Validator
Icon
Summary
13
The Multi-Table Query Generator
Icon
The Multi-Table Query Generator
Icon
Choosing Tables
Icon
Column Criteria
Icon
Automatic Joins
Icon
Executing the Query
Icon
Summary
14
Bookmarks
Icon
Bookmarks
Icon
Creating a Bookmark after a Successful Query
Icon
Storing a Bookmark before Sending a Query
Icon
Multi-Query Bookmarks
Icon
Recalling from the Bookmarks List
Icon
Public Bookmarks
Icon
The Default Initial Query for a Table
Icon
Bookmark Parameters
Icon
Executing Bookmarks by Browsing the pma_bookmark Table
Icon
Summary
15
System Documentation
Icon
System Documentation
Icon
The Database Print View
Icon
The Selective Database Print View
Icon
The Table Print View
Icon
The Data Dictionary
Icon
Relational Schema in PDF
Icon
Summary
16
MIME-Based Transformations
Icon
MIME-Based Transformations
Icon
The MIME Column's Settings
Icon
Requirements for Image Generation
Icon
Examples of Transformations
Icon
Summary
17
Character Sets and Collations
Icon
Character Sets and Collations
Icon
Language Files and UTF-8
Icon
Versions of MySQL Prior to 4.1.x
Icon
MySQL 4.1.x and Later
Icon
Kanji Support
Icon
Summary
18
MySQL 5.0 Features
Icon
MySQL 5.0 Features
Icon
Observations on the History of MySQL 5.0
Icon
Views
Icon
Routines: Stored Procedures and Functions
Icon
Triggers
Icon
Information_schema
Icon
Profiling
Icon
Summary
19
MySQL Server Administration
Icon
MySQL Server Administration
Icon
Entering the Server View
Icon
Database Information
Icon
Server Operations
Icon
Summary
20
Troubleshooting and Support
Icon
Troubleshooting and Support
Icon
System Requirements
Icon
Base Configuration
Icon
Solving Common Errors
Icon
Seeking Support
Icon
Contributing to the Project
Icon
Future phpMyAdmin Versions
Icon
Summary

Awards

phpMyAdmin has won some awards, as can be seen in the Awards section of the project's home page. First, it was awarded "Project of the Month" for December 2002 by the administrators of SourceForge. In the interview-style document we prepared to put on the SourceForge POTM page, I wrote that I was impressed by the download rate of our product, which was three per minute at that time. (Since then we have reached ten per minute on peak days.)

phpMyAdmin received 75% of the votes from the readers of both the German PHP Magazin and its international version, in the category "Best PHP Application/Tool" for 2003. This award was officially presented at the International PHP Conference held at Frankfurt in November 2003 to two members of the team. The German PHP Magazin hosted the readers choice again in 2005 and 2006; phpMyAdmin won for both years in the same category.

SourceForge.net hosted its Community Choice Awards for the first time in 2006 and phpMyAdmin won in two categories: Databases and System Administration. I represented the team at LinuxWorld, Boston in April for the awards presentation. The project also won "Best PHP Application of the Year" at the fifth Annual OS/2 World Awards. At the end of 2006, our project won a Silver Trophy at the third Trophées du Libre contest; I went to France to receive the trophy.

In 2007, at the SourceForge.net Community Choice Awards, phpMyAdmin was nominated in the "Best Tool or Utility for Developers" category, and won the "Best Tool or Utility for SysAdmins" award.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering phpMyAdmin 2.11 for Effective MySQL Management
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon