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 3.4 for Effective MySQL Management
  • Table Of Contents Toc
Mastering phpMyAdmin 3.4 for Effective MySQL Management

Mastering phpMyAdmin 3.4 for Effective MySQL Management

By : Delisle
4.3 (10)
Buy this Book
close
close
Mastering phpMyAdmin 3.4 for Effective MySQL Management

Mastering phpMyAdmin 3.4 for Effective MySQL Management

4.3 (10)
By: Delisle
Buy this Book

Overview of this book

phpmyAdmin is one of the most widely used open source applications, which is written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 52 languages.phpMyAdmin is a web-based front-end to manage MySQL databases and has been adopted by a number of Open-Source distributors.Mastering phpMyAdmin 3.4 for Effective MySQL Management is an easy-to-read, step-by-step practical guide that walks you through every facet of this legendary toolóphpMyAdminóand takes you a step ahead in taking full advantage of its potential. 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. It starts with installing and configuring phpMyAdmin, including the phpMyAdmin Configuration Storage, which is the key to its advanced features. This is followed by configuring authentication in phpMyAdmin and setting parameters that influence the interface as a whole.You will also learn some advanced features such as defining inter-table relations with the advanced Designer module. You will practice synchronizing databases on different servers and managing MySQL replication to improve performance and data security. Moreover, you will also store queries as bookmarks for their quick retrieval.In addition to it, this book helps you to learn new features introduced in version 3.4.x such as users' preferences, producing charts and the visual multi-table query builder.
Table of Contents (27 chapters)
close
close
close
Mastering phpMyAdmin 3.4 for Effective MySQL Management
Icon
Mastering phpMyAdmin 3.4 for Effective MySQL Management
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Getting Started with phpMyAdmin
chevron up
Icon
Getting Started with phpMyAdmin
Icon
PHP and MySQL: The leading open source duo
Icon
What is phpMyAdmin?
Icon
Installing phpMyAdmin
Icon
Configuring phpMyAdmin
Icon
Installing phpMyAdmin configuration storage
Icon
Upgrading phpMyAdmin
Icon
Summary
2
Configuring Authentication and Security
Icon
Configuring Authentication and Security
Icon
Logging in to MySQL through phpMyAdmin
Icon
Securing phpMyAdmin
Icon
Summary
3
Over Viewing the Interface
Icon
Over Viewing the Interface
Icon
Over viewing panels and windows
Icon
Customizing general settings
Icon
Character sets and collations
Icon
Navigation panel
Icon
Main panel
Icon
User preferences
Icon
Query window
Icon
Summary
4
Creating and Browsing Tables
Icon
Creating and Browsing Tables
Icon
Creating a database
Icon
Creating our first table
Icon
Inserting data manually
Icon
Browse mode
Icon
Profiling queries
Icon
Creating an additional table
Icon
Summary
5
Changing Data and Structure
Icon
Changing Data and Structure
Icon
Changing data
Icon
Changing table structure
Icon
Summary
6
Exporting Structure and Data (Backup)
Icon
Exporting Structure and Data (Backup)
Icon
Dumps, backups, and exports
Icon
Exporting a database
Icon
Exporting a table
Icon
Exporting selectively
Icon
Exporting multiple databases
Icon
Saving the export file on the server
Icon
Memory limits
Icon
Summary
7
Importing Structure and Data
Icon
Importing Structure and Data
Icon
Limits for the transfer
Icon
Importing SQL files
Icon
Importing CSV files
Icon
Importing other formats
Icon
Reading files from a web server upload directory
Icon
Displaying an upload progress bar
Icon
Summary
8
Searching Data
Icon
Searching Data
Icon
Single-table searches
Icon
Performing a complete database search
Icon
Stopping an errant query
Icon
Summary
9
Performing Table and Database Operations
Icon
Performing Table and Database Operations
Icon
Maintaining a table
Icon
Changing table attributes
Icon
Emptying or deleting a table
Icon
Renaming, moving, and copying tables
Icon
Performing other table operations
Icon
Multi-table operations
Icon
Database operations
Icon
Summary
10
Benefiting from the Relational System
Icon
Benefiting from the Relational System
Icon
Relational MySQL
Icon
Defining relations with the relation view
Icon
Defining relations with the Designer
Icon
Benefiting from the defined relations
Icon
Column commenting
Icon
Summary
11
Entering SQL Statements
Icon
Entering SQL Statements
Icon
The SQL query box
Icon
The Query window
Icon
Multi-statement queries
Icon
Pretty printing (syntax highlighting)
Icon
The SQL Validator
Icon
Summary
12
Generating Multi-table Queries
Icon
Generating Multi-table Queries
Icon
Choosing tables
Icon
Exploring column criteria
Icon
Generating automatic joins (internal relations)
Icon
Executing the query
Icon
The visual builder
Icon
Summary
13
Synchronizing Data and Supporting Replication
Icon
Synchronizing Data and Supporting Replication
Icon
Synchronizing data and structure
Icon
Supporting MySQL replication
Icon
Summary
14
Using Query Bookmarks
Icon
Using Query Bookmarks
Icon
Comparing bookmark and query history features
Icon
Creating bookmarks
Icon
Recalling bookmarks from the bookmarks list
Icon
Passing a parameter to a bookmark
Icon
Summary
15
Documenting the System
Icon
Documenting the System
Icon
Producing structure reports
Icon
Generating relational schemas
Icon
Summary
16
Transforming Data using MIME
Icon
Transforming Data using MIME
Icon
Browsing data without transformations
Icon
Enabling transformations
Icon
Examples of transformations
Icon
Summary
17
Supporting Features Added in MySQL 5
Icon
Supporting Features Added in MySQL 5
Icon
Supporting views
Icon
Supporting routines—stored procedures and functions
Icon
Executing code with triggers
Icon
Using information_schema
Icon
Partitioning
Icon
Exploring the event scheduler
Icon
Summary
18
Tracking Changes
Icon
Tracking Changes
Icon
Understanding the goals of the tracking system
Icon
Prerequisites
Icon
Principles
Icon
Initiating tracking for one table
Icon
Testing the tracking mechanism
Icon
Determining tracking status
Icon
Structure snapshot
Icon
Exporting a version
Icon
Creating a new version
Icon
Deleting tracking information
Icon
Summary
19
Administrating the MySQL Server
Icon
Administrating the MySQL Server
Icon
Managing users and their privileges
Icon
Database information
Icon
Server information
Icon
Summary
1
Troubleshooting and Support
Icon
Troubleshooting and Support
Icon
Troubleshooting
Icon
Seeking support
Icon
Contributing to the project
2
Index
Icon
Index

What is phpMyAdmin?

phpMyAdmin (official home page at http://www.phpmyadmin.net) is a web application written in PHP; it contains (like most web applications) XHTML, CSS, and JavaScript client code. This application provides a complete web interface for administering MySQL databases, and is widely recognized as the leading application in this field.

Being open source since its birth, it has enjoyed support from numerous developers and translators worldwide (being translated into 65 languages at the time of writing this book). The project is currently hosted at SourceForge.net and developed using their facilities by the phpMyAdmin team.

Host providers everywhere are showing their trust in phpMyAdmin by installing it on their servers. The popular cPanel (a website control application) contains phpMyAdmin. In addition, we can install our own copy of phpMyAdmin on our web server as long as our provider's server satisfies with the minimum requirements (refer to the System requirements section later in this chapter).

The goal of phpMyAdmin is to offer a complete web-based management of MySQL servers and data, and to keep up with MySQL and web standards evolution. While the product is always evolving, it supports all standard operations along with extra features.

The development team constantly fine-tunes the product based on the reported bugs and requested features, releasing new versions regularly.

phpMyAdmin offers features that cover basic MySQL database and table operations. It also has an internal system that maintains metadata to support advanced features. Finally, system administrators can manage users and privileges from phpMyAdmin. It is important to note that phpMyAdmin's choice of available operations depends on the rights the user has on a specific MySQL server.

Project documentation

Further information about phpMyAdmin is available on the home site's documentation page, located at http://www.phpmyadmin.net/home_page/docs.php. Moreover, the development team, helped by the community, maintains a wiki at http://wiki.phpmyadmin.net.

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 3.4 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