1.x 256
effective character set, MySQL version 4.1.x
260
exporting 263
importing and exporting 257
MySQL version, prior to 4.1.x 255
switching, MySQL version prior to 4.1.x
256
collation
about 253
MySQL version 4.1.x 258
column-commenting
about 192, 193
automatic migration 193
column criteria, multi-table query generator
columns in result, displaying 210
criteria columns, adjusting 215
criteria rows, adjusting 214
[ 308 ]
criteria rows, removing 215
field selector 209
LIKE criteria 211-213
query, updating 210, 211
sorting 209
config.inc.php file
about 27
creating, manually 27
editing, on Windows client 27
multi-server configuration 31
configuration parameters
$cfg[???AllowAnywhereRecoding??™] 254
$cfg[???AllowAnywhereRecording??™] 125
$cfg[???AllowArbitraryServer??™] 32
$cfg[???AllowUserDropDatabase??™] 95
$cfg[???AvailableCharsets??™] 255
$cfg[???BgcolorOne??™] 83
$cfg[???BgcolorTwo??™] 83
$cfg[???blowfish_secret??™] 35
$cfg[???BrowseMarkerColor??™] 81
$cfg[???BrowseMarkerEnable??™] 81
$cfg[???BrowseMIME??™] 239
$cfg[???BrowsePointerColor??™] 81
$cfg[???CharEditing??™] 74
$cfg[???CharTextareaRows??™] 75
$cfg[???CompressOnFly??™] 124
$cfg[???Confirm??™] 92
$cfg[???CtrlArrowsMoving??™] 87
$cfg[???DefaultCharset??™] 255
$cfg[???DefaultConnectionCollation??™] 261
$cfg[???DefaultDisplay??™] 77
$cfg[???DefaultLang??™] 46
$cfg[???DefaultPropDisplay??™] 98
$cfg[???DefaultQueryDatabase??™] 196
$cfg[???DefaultQueryTable??™] 196
$cfg[???DefaultTabDatabase??™] 60
$cfg[???DefaultTabServer??™] 62
$cfg[???DefaultTabTable??™] 61, 151
$cfg[???EditInWindow??™] 200
$cfg[???ErrorIconic??™] 45
$cfg[???ExecTimeLimit??™] 140
$cfg[???Export??™] 117
$cfg[???Export??™][???format??™] 117
$cfg[???file_template_database??™] 124
$cfg[???file_template_server??™] 124
$cfg[???file_template_table??™] 124
$cfg[???FilterLanguages??™] 47
$cfg[???ForeignKeyDropdownOrder??™] 190
$cfg[???ForeignKeyMaxLimit??™] 189, 190
$cfg[???GD2Available??™] 242
$cfg[???GZiDump??™] 124
$cfg[???HeaderFlipType??™] 78
$cfg[???IgnoreMultiSubmitErrors??™] 201
$cfg[???Import??™] 139
$cfg[???InsertRows??™] 73
$cfg[???Lang??™] 47
$cfg[???LeftBgColor??™] 50
$cfg[???LeftDisplayLogo??™] 50
$cfg[???LeftDisplayServers??™] 56
$cfg[???LeftFrameDBTree??™] 53
$cfg[???LeftFrameLight??™] 51
$cfg[???LeftFrameTableLevel??™] 55
$cfg[???LeftFrameTableSeparator??™] 55
$cfg[???LeftPointerColor??™] 50
$cfg[???LeftPointerEnable??™] 50
$cfg[???LeftWidth??™] 50
$cfg[???LightTabs??™] 62
$cfg[???LimitChars??™] 81, 247
$cfg[???LoginCookieRecall??™] 36
$cfg[???LongtextDoubleTextarea??™] 101
$cfg[???MainPageIconic??™] 49, 62
$cfg[???MaxRows??™] 79
$cfg[???MemoryLimit??™] 138, 141
$cfg[???ModifyDeleteAtLeft??™] 85
$cfg[???ModifyDeleteAtRight??™] 85
$cfg[???MySQLManualBase??™] 64
$cfg[???MySQLManualType??™] 64
$cfg[???NaturalOrder??™] 46
$cfg[???NavigationBarIconic??™] 79
$cfg[???OBGzip??™] 301
$cfg[???Order??™] 80
$cfg[???PDFDefaultPageSize??™] 235
$cfg[???PDFPageSizes??™] 235
$cfg[???PersistentConnections??™] 29
$cfg[???PmaAbsoluteUri??™] 28, 301
$cfg[???PmaNoRelation_DisableWarning??™]
173
$cfg[???PropertiesIconic??™] 85, 99
$cfg[???ProtectBinary??™] 103
$cfg[???QueryFrame??™] 63
$cfg[???QueryFrameJS??™] 198
$cfg[???QueryHistoryDB??™] 199
$cfg[???QueryHistoryMax??™] 199
$cfg[???QueryWindowDefTab??™] 198
[ 309 ]
$cfg[???QueryWindowHeight??™] 63
$cfg[???QueryWindowWidth??™] 63
$cfg[???RecodingEngine??™] 255
$cfg[???RepeatCells??™] 83
$cfg[???ReplaceHelpImg??™] 64
$cfg[???RestrictFunctions??™] 88
$cfg[???RightBgColor??™] 57
$cfg[???RightBgImage??™] 58
$cfg[???SaveDir??™] 138
$cfg[???ServerDefault??™] 32
$cfg[???Servers??™][$i] 31
$cfg[???Servers??™][$i][???AllowDeny??™][???order??™] 39
$cfg[???Servers??™][$i][???AllowDeny??™][???rules??™] 39
$cfg[???Servers??™][$i][???AllowRoot??™] 40
$cfg[???Servers??™][$i][???auth_type??™] 34, 36
$cfg[???Servers??™][$i][???bookmarktable??™]
175, 221
$cfg[???Servers??™][$i][???column_info??™] 175
$cfg[???Servers??™][$i][???connect_type??™] 30
$cfg[???Servers??™][$i][???controlpass??™] 176
$cfg[???Servers??™][$i][???controluser??™] 34, 176
$cfg[???Servers??™][$i][???extension??™] 29
$cfg[???Servers??™][$i][???hide_db??™] 40
$cfg[???Servers??™][$i][???history??™] 175, 200
$cfg[???Servers??™][$i][???host??™] 29
$cfg[???Servers??™][$i][???LogoutURL??™] 34
$cfg[???Servers??™][$i][???only_db??™] 40
$cfg[???Servers??™][$i][???password??™] 31
$cfg[???Servers??™][$i][???pdf_pages??™] 175
$cfg[???Servers??™][$i][???pmadb??™] 175
$cfg[???Servers??™][$i][???port??™] 29
$cfg[???Servers??™][$i][???relation??™] 175
$cfg[???Servers??™][$i][???SignonSession??™] 36
$cfg[???Servers??™][$i][???SignonURL??™] 37
$cfg[???Servers??™][$i][???socket??™] 29, 30
$cfg[???Servers??™][$i][???table_coords??™] 175
$cfg[???Servers??™][$i][???table_info??™] 175
$cfg[???Servers??™][$i][???user??™] 31
$cfg[???Servers??™][$i][???verbose??™] 29
$cfg[???Servers??™][$i][???verbose_check??™] 175
$cfg[???ShowAll??™] 79
$cfg[???ShowBlob??™] 102, 227
$cfg[???ShowBrowseComments??™] 193
$cfg[???ShowChgPassword??™] 58
$cfg[???ShowFunctionFields??™] 89
$cfg[???ShowPhpInfo??™] 59
$cfg[???ShowPropertyComments??™] 193
$cfg[???ShowSQL??™] 67
$cfg[???ShowStats??™] 59
$cfg[???ShowTooltipAliasDB??™] 164
$cfg[???SQLQuery??™][???Edit??™] 76
$cfg[???SQLQuery??™][???Explain??™] 76
$cfg[???SQLQuery??™][???Refresh??™] 77
$cfg[???SQLQuery??™][???ShowAsPHP??™] 76
$cfg[???SQLQuery??™][???Validate??™] 204
$cfg[???SQLValidator??™][???password??™] 204
$cfg[???SQLValidator??™][???username??™] 204
$cfg[???SQP??™][???fmtColor??™] 202
$cfg[???SQP??™][???fmtType??™] 202
$cfg[???SuggestDBName??™] 66
$cfg[???TextareaAutoSelect??™] 197
$cfg[???TextareaCols??™] 100
$cfg[???TextareaRows??™] 100
$cfg[???ThemeDefault??™] 48
$cfg[???ThemeManager??™] 49
$cfg[???ThemePath??™] 48
$cfg[???UploadDir??™] 148
$cfg[???UseDbSearch??™] 159
$cfg[???VerboseMultiSubmit??™] 200
$cfg[???WYSIWYG-PDF??™] 234
$cfg[Border] 83
$cfg[MaxExactCount] 60
$cfg[PmaAbsoluteUri] 303
$cfg[RestrictColumnTypes] 88
$cfg[ShowFunctionFields] 87
$cfg[ShowTooltipAliasTB] 164
$cfg[ThBgcolor] 83
$cfg[ThemePerServer] 49
cfg[???ShowHttpHostTitle??™] 45
connection, phpMyAdmin
configuring 21
configuring principles 21, 22
MySQL server, parameters 25
PmaAbsoluteUri parameter 28
server specific sections 28
testing 31
web-based setup, warnings 23, 24
web-based setup script 22-27
contributing to phpMyAdmin project
code base 306
future versions 306
patches 306
translation updates 306
control user 33
[ 310 ]
CSV
files, importing 143-145
import using LOAD DATA 146
import using LOAD DATA,
requirements 146
import using LOAD DATA interface 147
LOAD DATA INFILE statement 146
LOAD DATA LOCAL INFILE
statement 146
upload directory 148
CSV format, database export
about 125
CSV options 125, 126
for MS Excel 126
D
data
deleting 91
functions, applying to data 87
importing 139
importing, CSV files 143, 145
importing, file size limits 140
importing, memory limits 141
importing, other limits 140
importing, SQL files 142, 143
importing, time limits 140
importing, transfer limits 140
partial importing 141
searching 151
database
additional table, creating 83, 84
copy operation 169
creating 65
Data dictionary 231
deleting 95
Designer feature 237
export 116, 117
multi-table query generator 207
mutiple table operations 167
Print view 229
renaming operation 169
searching 158, 160
table, creating 68
table attributes 162
table maintenance 162
database, creating
about 65
authorized database creation 66
CREATE privilege 66
home page, MySQL 66
no privileges 65
database export
about 116
CSV format 125
CSV for MS Excel 126
formats 117
LaTeX format 128
Microsoft Excel 2000 format 127
Microsoft Word 2000 format 128
multi-database export 136
Native MS Excel format 130, 131
Open Document spreadsheet format 131
Open Document text format 132
PDF format 127
Save as file sub-panel 123
SQL format 117, 119
sub-panel, export 117
XML format 129
YAML format 132
database information, MySQL server
about 290
database privileges, checking 291
selected databases, dropping 292
statistics, enabling 291
statistics, sorting 291
database operations
copying 169
renaming 169
data deleting
about 91
multi-rows, deleting 92
rows, deleting 93
rows of mutiple tables, deleting 94
single row, deleting 92
data editing
data navigation 86
edit icon 86
edit mode 85, 86
function names display, restricting 88
functions, applying to data 87
handling null values, edit mode 87
[ 311 ]
multi-row, editing 90
row, deleting 85
row, editing 85
rows of data, duplicating 89
sequential editing 91
defined relations, benefits
browsable foreign-table window 190
foreign key information 188-190
metadata, automatic update 191
referential integrity check 191
Designer
about 184
display field about 188
InnoDB relations 187
interface overview 184
menu icons 185, 186
PDF schema, exporting to 188
relations, about 186, 187
relations, defining with 184
documentation, phpMyAdmin
database, Print view 229
Data dictionary 231
image generation, requirements 242
PDF pages, displaying 235
PDF pages, planning 233
Print view 229
selective database, Print view 230
table, Print view 230
E
ENUM and SET FIELDS, comparing 103
ENUM field 103
error messages, phpMyAdmin
BLOB related errors 301
connection problem, to local MySQL
server 299
error 127, table repairing problem 300
error 404, page not found 301
header information adding problem 300
IIS, no input file specified 301
MySQL, access denied 300
MySQL extension loading problem 298
named pipe problem 299
password transmission problems 300
server not responding, error #2003 299
socket problem 299
export file
on Linux system 137
saving on server 136
F
field
adding 97, 98
attributes, editing 99
BIT field 107, 108
BLOB fields 101
DATE field 105
DATETIME field 105
ENUM field 103
SET field 103
TEXT field 100
TEXT field, layouts controlling 100
TIMESTAMP field 105
foreign keys
drop-down list 189, 190
information 188
functions, MySQL 5.
Pages:
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277