Mastering PHP MyAdmin 3.3.x for Effective MySQL Management | Complete Guide To PHP

PHP Programming Book | Learn PHP Language |
Click Here To Download Book
Pages 412
Views 3272
Size 5.6 MB
Download 43
Table Of Contents

Chapter 1: Getting Started with phpMyAdmin
Introducing phpMyAdmin
Web applications
PHP and MySQL: The leading open source duo
What is phpMyAdmin?
Project documentation
Installing phpMyAdmin
Required information
System requirements
Downloading the files
Installing on different platforms
Installing on a remote server using a Windows machine
Installing on a local Linux server
Installing on local Windows servers (Apache, IIS)
Configuring phpMyAdmin
The file
Avoiding false error messages about permissions on
Configuration principles
Web-based setup script
Manually creating
Tips for editing on a Windows client
Description of some configuration parameters
Server-specific sections
Upgrading phpMyAdmin
Chapter 2: Configuring Authentication and Security
Logging in to MySQL through phpMyAdmin
Logging in to an account without a password
Authenticating a single user with config
Testing the MySQL connection
Authenticating multiple users
Authentication types offered
The control user
Logging out
Authenticating with HTTP
Authenticating users with cookie values
Authenticating through the signon mode
Configuring for multiple server support
Defining servers in the configuration file
Authenticating through an arbitrary server
Securing phpMyAdmin
Protecting phpMyAdmin at the directory level
Displaying error messages
Protecting with IP-based access control
Defining rules
Order of interpretation for rules
Blocking root access
Protecting in-transit data
Authenticating using Swekey hardware
Configuring Swekey authentication
Using phpMyAdmin in a Swekey context
Security note
Access logging
Available information
Configuring Apache
Chapter 3: Over Viewing the Interface
Over viewing panels and windows
Login panels
Navigation and main panels
Home page
Query window
Starting page
Customizing general settings
Configuring the window title
Configuring icons
Natural sort order for database and table names
Creating site-specific headers and footers
Displaying MySQL documentation links
Configuring themes
Selecting themes
Assigning colors using the color picker
Limiting URL lengths
Restricting the list of databases
Character sets, collations, and language
Unicode and UTF-8
Selecting languages
Effective character sets and collations
Navigation panel
Configuring the logo
Database and table list
Light mode
Full mode
Table short statistics
Table quick-access icon
Nested display of tables within a database
Choosing from the server list
Handling many databases or tables
Limits on the interface
Improving fetch speed
Main panel
Home page
Database view
Table view
Server view
Icons for the home page and menu tabs
Opening a new phpMyAdmin window
Query window
Chapter 4: Taking First Steps
Creating a database
No privileges?
First database creation is authorized
Creating our first table
Choosing the fields
Creating a table
Choosing keys
Inserting data manually
Data entry panel tuning for CHAR and VARCHAR
Browse mode
SQL query links
Navigation bar
Query results operations
Sorting results
Color-marking rows
Limiting the length of each column
Display options
Browsing distinct values
Customizing the browse mode
Creating an additional table
Chapter 5: Changing Data and Structure
Changing data
Entering edit mode
Moving to the next field with the tab key
Moving with arrows
Handling NULL values
Applying a function to a value
Duplicating rows of data
Multi-row editing
Editing the next row
Deleting data
Deleting a single row
Deleting many rows
Deleting all of the rows in a table
Deleting all rows in many tables
Deleting tables
Deleting databases
Changing a table’s structure
Adding a field
Vertical mode
Horizontal mode
Editing field attributes
TEXT fields
BLOB (Binary Large Object) fields
Uploading binary content
ENUM and SET fields
Calendar pop up
Bit fields
Managing indexes
Single-field indexes
Multi-field indexes and index editing
FULLTEXT indexes
Optimizing indexes with EXPLAIN
Detecting index problems
Chapter 6: Exporting Structure and Data (Backup)
Dumps, backups, and exports
Scope of the export
Exporting a database
The export subpanel
Defining options for SQL export
The “Save as file” subpanel
File name template
Choosing a character set
Kanji support
CSV for MS Excel
Microsoft Word 2000
Open document spreadsheet
Open document text
Texy! text
PHP array
Excel 97-2003 and Excel 2007 Workbook
MediaWiki table
Exporting a table
Split-file exports
Exporting selectively
Exporting partial query results
Exporting and checkboxes
Exporting multiple databases
Saving the export file on the server
User-specific save directories
Memory limits
Chapter 7: Importing Structure and Data
Limits for the transfer
Time limits
Other limits
Handling big export files
Uploading into a temporary directory
Importing SQL files
Importing CSV files
Differences between SQL and CSV formats
Exporting a test file
Using the LOAD DATA interface
Importing other formats
Open Document Spreadsheet
Reading files from a web server upload directory
Displaying an upload progress bar
Configuring APC
Displaying a character set dialog
Chapter 8: Searching Data
Using Search page daily
Single-table searches
Entering the search subpage
Searching criteria by field—query by example
Searching for empty or non-empty values
Producing reports with Print view
Searching with wildcard characters
Performing a case-sensitive search
Combining criteria
Search options
Selecting the fields to be displayed
Ordering the results
Applying a WHERE clause
Avoiding repeated results
Performing a complete database search
Restricting the search to a column
Stopping an errant query
Chapter 9: Performing Table and Database Operations
Maintaining a table
Changing table attributes
Table storage engine
Table comments
Table order
Table collation
Table options
Renaming, moving, and copying tables
Appending data to a table
Multi-table operations
Repairing an “in use” table
Database operations
Renaming a database
Copying a database
Chapter 10: Benefiting from the Relational System
Relational MySQL
InnoDB and PBXT
Linked-tables infrastructure
Goal of the infrastructure
Location of the infrastructure
Installing the linked-tables infrastructure
Installing for a single user
Installing for multiple users
Defining relations with the relation view
Defining internal relations
Defining the relation
Defining the display field
Foreign key relations
Foreign keys without linked-tables infrastructure
Defining relations with the Designer
Over viewing the interface
Defining relations
Defining foreign key relations
Defining the display field
Exporting for PDF schema
Benefiting from the defined relations
Foreign key information
The drop-down list of foreign keys
The browsable foreign-table window
Referential integrity checks
Automatic updates of metadata
Automatically migrating column comments
Chapter 11: Entering SQL Commands
The SQL query box
The Database view
The Table view
The Fields selector
Clicking into the query box
The Query window
Query window options
Session-based SQL history
Database-based SQL history (permanent)
Editing queries in the query window
Multi-statement queries
Pretty printing (syntax-highlighting)
The SQL Validator
System requirements
Making the Validator available
Validator results
Standard-conforming queries
Non-standard-conforming queries
Chapter 12: Generating Multi-table Queries
Choosing tables
Exploring column criteria
Field selector: Single-column or all columns
Sorting columns
Showing a column
Updating the query
Adding conditions to the criteria box
Adjusting the number of criteria rows
Adjusting the number of criteria columns
Generating automatic joins
Executing the query
Chapter 13: Synchronizing Data and Supporting Replication
Synchronizing data and structure
Goals of synchronization
Moving between the development and production servers
Collaboration between database designers
Preparing for replication
Over viewing the synchronization process
Preparing for the synchronization exercise
Choosing source and target servers and databases
Analyzing comparison results
Performing a complete synchronization
Performing a selective synchronization
Supporting MySQL replication
The Replication menu
Configuring replication
Master server configuration
Slave server configuration
Setting up a test environment
Controlling a slave server
Obtaining replication information
Gathering replication status
Replicated databases
Replicated tables
Chapter 14: Using Bookmarks
Comparing bookmark and query history features
Creating bookmarks
Creating a bookmark after a successful query
Storing a bookmark before sending a query
Making bookmarks public
The default initial query for a table
Multi-query bookmarks
Recalling bookmarks from the bookmarks list
Executing bookmarks
Manipulating bookmarks
Bookmark parameters
Creating a parameterized bookmark
Passing a parameter value to a bookmark
Executing bookmarks by browsing the pma_bookmark table
Chapter 15: Documenting the System
Producing structure reports
Creating a printable report
The database print view
The selective database print view
The table print view
Preparing a complete report with the data dictionary
Generating relational schemas in PDF
Adding a third table to our model
Editing PDF pages
Page planning
Creating a new page
Editing a page
Displaying a page
Changing the font in PDF schema
Laying out a PDF schema with the Designer feature
Chapter 16: Transforming Data Using MIME
Browsing data without transformations
Switching display options
Enabling transformations
Configuring settings for MIME columns
Selecting the MIME type
Browser transformations
Assigning values to transformation options
Requirements for image generation
Configuring GD2 library availability verification
Asserting support of JPEG and PNG libraries
Evaluating the impact of memory limits
Examples of transformations
Clickable thumbnail (.jpeg or .png)
Adding links to an image
Date formatting
Links from text
text/plain: link
text/plain: imagelink
Preserving the original formatting
Displaying parts of a text
Displaying a download link
Hexadecimal representation
SQL pretty printing
IP address
Transforming data via external applications
External application example: In-cell sort
Chapter 17: Supporting MySQL 5.0 and 5.1
Activating support for views
Manually creating a view
Main panel and views
Creating a view from results
Renaming a view
Controlling row counting for improved performance
Supporting routines—stored procedures and functions
Creating a stored procedure
Changing the delimiter
Entering the procedure
Testing the procedure
Manipulating procedures and functions
Manually creating a function
Testing the function
Exporting stored procedures and functions
Executing code with triggers
Manually creating a trigger
Testing the trigger
Using information_schema
Creating a table with partitions
Maintaining partitions
Exporting a partition definition
Exploring the Event Scheduler
Activating the scheduler
Granting EVENT permission
Creating an event
Manipulating events
BLOB streaming
System requirements
Configuring BLOB streaming
Examining implementation limitations in phpMyAdmin
Creating the PBMS system tables
Preparing the table
Uploading to the BLOB repository
Streaming the data from the repository
Changing repository data
Chapter 18: Tracking Changes
Understanding the goals of the tracking system
Tracking in other software applications
Tracking in phpMyAdmin
Configuring a basic tracking mechanism
Taking a snapshot of the current structure
Understanding archiving issues
Initiating tracking for one table
Choosing the statements to be tracked
Testing the tracking mechanism
Tracking report
Determining tracking status
Deactivating and activating tracking
Structure snapshot
Exporting a version
Creating a new version
Quickly accessing tracking information
Deleting tracking information
Chapter 19: Administrating the MySQL Server with phpMyAdmin
Managing users and their privileges
The user overview
Privileges reload
Adding a user
Entering the username
Assigning a host value
Setting passwords
Understanding rights for database creation
Assigning global privileges
Limiting the resources used
Editing a user profile
Editing privileges
Assigning database-specific privileges
Changing the password
Changing login information or copying a user
Removing a user
Database information
Enabling statistics
Sorting statistics
Checking the database privileges
Dropping selected databases
Server information
Verifying server status
The general status page
InnoDB status
Server variables
Server processes
Storage engines
Available character sets and collations
Examining binary logs
Appendix A: The History of phpMyAdmin
Early events
Project re-launch
GoPHP5 and the 3.x branch
Future phpMyAdmin versions
Appendix B: Troubleshooting and Support
System requirements
Verifying the base configuration
Solving common errors
Troubleshooting error messages
Cannot load MySQL extension
#2003 – Can’t connect to MySQL server
Socket problem (Linux/UNIX)
Named pipe problem (Windows)
MySQL said: Access denied
When using http authentication
When using http, cookie, or config authentication
Access denied … “using password: NO”
Access denied … “using password: YES”
Login without a password is forbidden by configuration
Warning: cannot add header information
MySQL said: Error 127, Table Must Be Repaired
BLOB column used in key specification without a key length
IIS: No Input File Specified
A “404: page not found” error when modifying a row
Troubleshooting other problems
Blank page or weird characters
Not being able to create a database
Problems importing large files or uploading large BLOB files
MySQL root password lost
Duplicate field names when creating a table
Authentication window displayed more than once
Column size changed by phpMyAdmin
Seeing many databases that are not ours
Not being able to store a value greater than 127
Seeking support
Help forums
Creating a SourceForge account
Choosing the thread title
Reading the answers
Using the support tracker
Using the bug tracker
Environment description
Bug description
Contributing to the project
The code base
Translation updates