0
creating, manually 273
exporting 274
testing 274
I
iconv module
data recoding 254
image generation, requirements
about 242
GD2 library 242
JPEG and PNG library 242
memory 243
importing data
CSV files 143, 145
file size limits 140
file uploads 141
LOAD DATA INFILE statement 139
memory limits 141
other limits 140
SQL and CSV formats, comparing 143
SQL files 142, 143
time limits 140
transfer limits 140
index management 70
[ 312 ]
EXPLAIN statement 113
Fulltext indexes 111
index, editing 110
index problems, detecting 113
multi-field indexes 110
MyISAM tables 111
single-field indexes 108, 109
table optimization 112
InnoDB
about 172
advantages 172
foreign key feature 172
relations 180-183
status in MySQL server 293
tables 172
tables without linked tables infrastructure
183
installing, phpMyAdmin
on Apache 20
on IIS 20
on local Linux server 20
on local Windows servers 20
on remote server, Windows client used
19, 20
IP-based access control
about 38
order of interpretation for rules 39, 40
root access, rule 40
rules 38
L
LaTeX format, database export
about 128
options 129
left panel, phpMyAdmin
about 43
additional table, creating 83, 84
database, selecting 50, 51
database names, tree display 52
database view, full mode form 53
database view, light mode form 52
elements 49
full mode form 53
light mode, form 51
numerous databases, handling 56
numerous tables, handling 56
server-list 56
table, quick browsing 54
tables, nested display within database
54, 55
table short statistics 54
table view, full mode form 53
linked-tables
bookmarks 219
functions 175
infrastructure 172
infrastructure, goal 173
infrastructure, installing 173, 174
infrastructure, location 173
InnoDB tables without linked tables
infrastructure 183
multi-user installation 174, 175
relation view 177
single-user installation 176, 177
M
metadata 171
column-commenting 192
MIME
browser transformations 241
columns settings 240
download link 248
transformation options 241
transformation settings 239
type 240
multi-table query generator
about 207
automatic joins, between tables 216
column criteria 209
columns in result, displaying 210
criteria columns, adjusting 215
criteria rows, adjusting 214
criteria rows, removing 215
field selector 209
LIKE criteria 211, 212, 213
query, executing 216
query, updating 210, 211
sorting 209
tables, selecting 208, 209
mutiple table operations
about 167
repairing in-use table 168
[ 313 ]
MySQL
about 8
backup 115
BLOB fields 101
browse mode 75
character set 253
collation 253
control user 33
database, creating 65
dump 115
export 115
functions, applying to data 87
index management 112
information_schema 278
InnoDB 172
LOAD DATA INFILE statement 146
LOAD DATA LOCAL INFILE
statement 146
MySQL 5.
Pages:
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277