inc.php 27
Tips for Editing config.inc.php on a Windows Client 27
The config.inc.php File 27
PmaAbsoluteUri 28
Server-Specific Sections 28
extension 29
PersistentConnections 29
connect_type, socket and port 29
compress Configuration 30
Authentication Type: config 30
Table of Contents
[ ii ]
Testing the First Connection 31
Multi-Server Configuration 31
Servers Defined in the Configuration File 31
Arbitrary Server 32
Advanced Authentication 33
Authentication Types Offered 33
The Control User 33
Logging Out 34
HTTP Authentication 34
Cookie Authentication 35
Signon 36
Security 37
Directory-Level Protection 37
IP-Based Access Control 38
Rules 38
Order of Interpretation for Rules 39
Simplified Rule for Root Access 40
Restricting the List of Databases 40
Protecting In-Transit Data 41
Upgrading phpMyAdmin 41
Summary 42
Chapter 3: Interface Overview 43
Panels and Windows 43
Login Panels 43
Left and Right Panels 43
Home Page 44
Views 44
Query Window 45
Starting Page 45
Window Titles Configuration 45
General Icon Configuration 45
Natural Sort Order for Database and Table Names 46
Language Selection 46
Themes 48
Theme Configuration 48
Theme Selection 49
Left Panel 49
Logo Configuration 50
Database and Table List 50
Light Mode 51
Full Mode 53
Table Short Statistics 54
Table of Contents
[ iii ]
Quick-Browsing a Table 54
Nested Display of Tables within a Database 54
Server-List Choice 56
Handling Many Databases or Tables 56
Right Panel 57
Home Page 58
Database View 59
Table View 61
Server View 62
Icons for Home Page and Menu Tabs 62
Query Window 63
Site-Specific Header and Footer 64
MySQL Documentation Links 64
Summary 64
Chapter 4: First Steps 65
Database Creation 65
No Privileges? 65
First Database Creation Is Authorized 66
Creating Our First Table 68
Choosing the Fields 68
Table Creation 68
Choosing Keys 70
Manual Data Insertion 72
Data Entry Panel Tuning for CHAR and VARCHAR 74
Browse Mode 75
SQL Query Links 76
Navigation Bar 77
Query Results Operations 79
Sorting Results 80
Color-Marking Rows 81
Limiting the Length of Each Column 81
Browsing Distinct Values 82
Browse-Mode Customization 83
Creating an Additional Table 83
Summary 84
Chapter 5: Changing Data 85
Edit Mode 85
Moving to Next Field with the Tab Key 86
Moving with Arrows 87
Handling NULL Values 87
Table of Contents
[ iv ]
Applying a Function to a Value 87
Duplicating Rows of Data 89
Multi-Row Editing 90
Editing the Next Row 91
Deleting Data 91
Deleting a Single Row 92
Deleting Many Rows 92
Deleting All the Rows in a Table 93
Deleting All Rows in Many Tables 94
Deleting Tables 94
Deleting Databases 95
Summary 95
Chapter 6: Changing Table Structures 97
Adding a Field 97
Vertical Mode 98
Horizontal Mode 99
Editing Field Attributes 99
TEXT 100
BLOB (Binary Large Object) Fields 101
Binary Contents Uploads 102
ENUM and SET 103
DATE, DATETIME, and TIMESTAMP 105
Calendar Popup 105
TIMESTAMP Options 107
Bit 107
Index Management 108
Single-Field Indexes 108
Multi-Field Indexes and Index Editing 109
FULLTEXT Indexes 111
Table Optimization: Explaining a Query 112
Detection of Index Problems 113
Summary 114
Chapter 7: Exporting Structure and Data 115
Dumps, Backups, and Exports 115
Database Exports 116
The Export Sub-Panel 117
SQL Options 119
The Save as file Sub-Panel 123
File Name Template 123
Compression 124
Choice of Character Set 125
Table of Contents
[ v ]
CSV 125
CSV for MS Excel 126
PDF 127
Microsoft Word 2000 128
Native MS Excel (pre-Excel 2000) 130
Open Document Text 132
YAML 132
Table Exports 133
Split-File Exports 133
Selective Exports 134
Exporting Partial Query Results 134
Exporting and Checkboxes 135
Multi-Database Exports 136
Saving the Export File on the Server 136
User-Specific Save Directories 138
Memory Limits 138
Summary 138
Chapter 8: Importing Structure and Data 139
Limits for the Transfer 140
Time Limits 140
Other Limits 140
Partial Imports 141
Temporary Directory 141
Importing SQL Files 142
Importing CSV Files 143
Differences between SQL and CSV Formats 143
Exporting a Test File 144
CSV 144
CSV Using LOAD DATA 146
Requirements 146
Using the LOAD DATA Interface 146
Web Server Upload Directories 147
Summary 149
Chapter 9: Searching Data 151
Single-Table Searches 151
Daily Usage of phpMyAdmin 151
Entering the Search Sub-Page 152
Selection of Display Fields 153
Ordering the Results 153
Search Criteria by Field: Query by Example 154
Print View 155
Table of Contents
[ vi ]
Wildcard Searching 155
Combining Criteria 157
Applying a WHERE Clause 157
Obtaining Distinct Results 158
Complete Database Search 158
Summary 160
Chapter 10: Table and Database Operations 161
Table Maintenance 162
Changing Table Attributes 162
Table Type 163
Table Comments 163
Table Order 164
Table Options 165
Renaming, Moving, and Copying Tables 166
Appending Data to a Table 167
Multi-Table Operations 167
Repairing an "in use" Table 168
Database Operations 168
Renaming a Database 169
Copying a Database 169
Summary 169
Chapter 11: The Relational System 171
Relational MySQL? 171
InnoDB 172
Linked-Tables Infrastructure 172
Goal of the Infrastructure 172
Location of the Infrastructure 173
Installing Linked-Tables Infrastructure 173
Multi-User Installation 174
Single-User Installation 176
Defining Relations with the Relation View 177
Internal Relations 178
Defining the Relation 178
Defining the Display Field 179
InnoDB Relations 180
InnoDB Tables without Linked-Tables Infrastructure 183
Defining Relations with the Designer 184
Interface Overview 184
Defining Relations 186
InnoDB Relations 187
Defining the Display Field 188
Table of Contents
[ vii ]
Exporting for PDF Schema 188
Benefits of the Defined Relations 188
Foreign Key Information 188
The Drop-Down List of Foreign Keys 189
The Browseable Foreign-Table Window 190
Referential Integrity Checks 191
Automatic Updates of Metadata 191
Column-Commenting 192
Automatic Migration 193
Summary 193
Chapter 12: Entering SQL Commands 195
The SQL Query Box 195
The Database View 195
The Table View 196
The Fields Selector 197
Clicking Into the Query Box 197
The Query Window 197
Query Window Options 198
Session-Based SQL History 199
Database-Based SQL History (Permanent) 199
Editing Queries in the Query Window 200
Multi-Statement Queries 200
Pretty Printing (Syntax-Highlighting) 202
The SQL Validator 203
System Requirements 203
Making the Validator Available 204
Validator Results 204
Standard-Conforming Queries 204
Non Standard-Conforming Queries 205
Summary 206
Chapter 13: The Multi-Table Query Generator 207
Choosing Tables 208
Column Criteria 209
Field Selector: Single-Column or All Columns 209
Sorts 209
Showing a Column 210
Updating the Query 210
Criteria 211
Adjusting the Number of Criteria Rows 214
Adjusting the Number of Criteria Columns 215
Automatic Joins 216
Table of Contents
[ viii ]
Executing the Query 216
Summary 217
Chapter 14: Bookmarks 219
Creating a Bookmark after a Successful Query 220
Storing a Bookmark before Sending a Query 221
Multi-Query Bookmarks 222
Recalling from the Bookmarks List 222
Bookmark Execution 223
Bookmark Manipulation 223
Public Bookmarks 223
The Default Initial Query for a Table 224
Bookmark Parameters 225
Creating a Parameterized Bookmark 225
Passing a Parameter Value to a Bookmark 226
Executing Bookmarks by Browsing the pma_bookmark Table 226
Summary 227
Chapter 15: System Documentation 229
The Database Print View 229
The Selective Database Print View 230
The Table Print View 230
The Data Dictionary 231
Relational Schema in PDF 231
Adding a Third Table to Our Model 231
Editing PDF Pages 232
Page Planning 233
Creating a New Page 233
Editing a Page 233
Displaying a Page 235
A Note about Fonts Used 236
Using the Designer for PDF Layout 237
Summary 238
Chapter 16: MIME-Based Transformations 239
The MIME Column's Settings 240
MIME Types 240
Browser Transformations 241
Transformation Options 241
Requirements for Image Generation 242
The GD2 Library 242
The JPEG and PNG Libraries 242
Memory Limits 243
Table of Contents
[ ix ]
Examples of Transformations 243
Clickable Thumbnail (.
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25