Index_B

B

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