|
|
back_log variable, 373, 379
backslash (\), for directory, vs. escape character, 305
BACKUP TABLE statement, 483
backups, 301
binary update log for, 274, 329– 332
of InnoDB tables, 332–335
of MyISAM tables
with BACKUP command, 302–305
by direct copying files, 307– 309
restoring, 305–307
with mysqldump, 309–315
restoring database backed up with, 311–315
with mysqlhotcopy, 327–328
replication as, 335
with SELECT INTO, 315–318
restoring database with LOAD DATA, 318–325
restoring database with mysqlimport, 325–326
basedir variable, 379
batch mode, 102–103
mysql command option for, 52
reasons for using, 105
bdb-no-sync variable, 379
bdb-non-recover variable, 379
BDB tables, 66, 115–117
bdb_cache_size variable, 379
bdb_home variable, 379
bdb_lock_detect variable, 379
bdb_log_buffer_size variable, 379
bdb_logdir variable, 379
bdb_max_lock variable, 379
bdb_shared_data variable, 380
bdb_tmpdir variable, 380
beep on error, mysql command option for, 52
beforeFirst() method (Java), 633
begin() method (Python), 621
BEGIN statement, 105, 483
and transaction completion, 117
begin_work method (Perl DBI), 600
BENCHMARK() function, 170–171, 558
benchmarks, 394–408
Berkeley Database, 66
BETWEEN comparison operator, 70, 506
BIGINT column type, 43
BIG_TABLES variable, 392, 495
bin directory, 452
BIN() function, 525
binary distribution of MySQL
directories, 452
installing on Unix
rpm, 458
tar, 455–457
installing on Windows, 453–455
vs. source code, 451–453
binary numbering system, 80–82
binary update log, 272, 273–276
for backups, 329–332
and replication, 337
with active log on master, 350–351
removing old before starting, 352–354
bind_col method (Perl DBI), 604
bind_columns method (Perl DBI), 604–605
bind_param method (Perl DBI), 605– 606
bind_param_array method (Perl DBI), 606–607
bind_param_inout method (Perl DBI), 607
binlog_cache_size variable, 380
BIT column type, 42
bit operators in SQL, 79–84, 509–511
&, 82, 510
|, 82, 510
<<, 83, 510
>>, 83–84, 511
BIT_AND() function, 555
BIT_LENGTH() function, 526
BIT_OR() function, 555–556
BLOB column type, 46
index for, 141
BOOL column type, 42
Boolean full-text searches, 135–140
boot up, starting MySQL automatically at, 264–265
Boyce-Codd normal form, 229–232
buffer, mysql command option to flush, 53
Bytes_received variable, 388
Bytes_sent variable, 388
|
|