~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

to display the contents of relay log files written by a slave server in a replication setup because relay logs have the same format as binary logs\&. The binary log and relay log are discussed further in

Section\ \&5.2.4, \(lqThe Binary Log\(rq, and

Section\ \&16.2.2, \(lqReplication Relay and Status Files\(rq\&.

Section\ \&15.2.2, \(lqReplication Relay and Status Logs\(rq\&.

.PP

Invoke

\fBmysqlbinlog\fR

.PP

The output includes events contained in

binlog\&.000003\&. For statement\-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so forth\&. For row\-based logging, the event indicates a row change rather than an SQL statement\&. See

Section\ \&16.1.2, \(lqReplication Formats\(rq, for information about logging modes\&.

Section\ \&15.1.2, \(lqReplication Formats\(rq, for information about logging modes\&.

.PP

Events are preceded by header comments that provide additional information\&. For example:

.sp

124

[mysqlbinlog]

125

and

126

[client]

127

option file groups\&.

127

groups of an option file\&.

128

\fBmysqlbinlog\fR

129

also supports the options for processing option files described at

130

Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.

159

.sp

160

This option determines when events should be displayed encoded as base\-64 strings using

161

BINLOG

162

statements\&. The option has these allowable values (not case sensitive):

162

statements\&. The option has these permissible values (not case sensitive):

163

.sp

164

.RS 4

165

.ie n \{\

174

UNSPEC

175

("unspecified") displays

176

BINLOG

177

statements automatically when necessary (that is, for format description events and row events)\&. This is the default if no

177

statements automatically when necessary (that is, for format description events and row events)\&. If no

178

\fB\-\-base64\-output\fR

179

option is given\&.

179

option is given, the effect is the same as

180

\fB\-\-base64\-output=AUTO\fR\&.

180

181

.if n \{\

181

182

.sp

182

183

.\}

209

210

ALWAYS

210

211

displays

211

212

BINLOG

212

statements whenever possible\&. This is the implied value if the option is given as

213

statements whenever possible\&. If the

213

214

\fB\-\-base64\-output\fR

214

without a value\&.

215

option is given without a value, the effect is the same as

216

\fB\-\-base64\-output=ALWAYS\fR\&.

215

217

.RE

216

218

.sp

217

219

.RS 4

283

285

.sp -1

284

286

.IP \(bu 2.3

285

287

.\}

288

.\" mysqlbinlog: bind-address option

289

.\" bind-address option: mysqlbinlog

290

\fB\-\-bind\-address=\fR\fB\fIip_address\fR\fR

291

.sp

292

On a computer having multiple network interfaces, this option can be used to select which interface is employed when connecting to the MySQL server\&.

293

.sp

294

This option is supported only in the version of

295

\fBmysqlbinlog\fR

296

that is supplied with MySQL Cluster, beginning with MySQL Cluster NDB 6\&.3\&.4\&. It is not available in standard MySQL 5\&.1 releases\&.

297

.RE

298

.sp

299

.RS 4

300

.ie n \{\

301

\h'-04'\(bu\h'+03'\c

302

.\}

303

.el \{\

304

.sp -1

305

.IP \(bu 2.3

306

.\}

286

307

.\" mysqlbinlog: character-sets-dir option

287

308

.\" character-sets-dir option: mysqlbinlog

288

309

\fB\-\-character\-sets\-dir=\fR\fB\fIpath\fR\fR

452

473

.br

453

474

This option did not work correctly for

454

475

\fBmysqlbinlog\fR

455

with row\-based logging prior to MySQL 5\&.1\&.37\&. (\m[blue]\fBBug#42941\fR\m[]\&\s-2\u[1]\d\s+2)

476

with row\-based logging prior to MySQL 5\&.1\&.37\&. (Bug #42941)

456

477

.sp .5v

457

478

.RE

458

479

.RE

606

627

Prepare local temporary files for

607

628

LOAD DATA INFILE

608

629

in the specified directory\&.

630

.if n \{\

631

.sp

632

.\}

633

.RS 4

634

.it 1 an-trap

635

.nr an-no-space-flag 1

636

.nr an-break-flag 1

637

.br

638

.ps +1

639

\fBImportant\fR

640

.ps -1

641

.br

642

These temporary files are not automatically removed by

643

\fBmysqlbinlog\fR

644

or any other MySQL program\&.

645

.sp .5v

646

.RE

609

647

.RE

610

648

.sp

611

649

.RS 4

702

740

.\" protocol option: mysqlbinlog

703

741

\fB\-\-protocol={TCP|SOCKET|PIPE|MEMORY}\fR

704

742

.sp

705

The connection protocol to use for connecting to the server\&. It is useful when the other connection parameters normally would cause a protocol to be used other than the one you want\&. For details on the allowable values, see

743

706

744

Section\ \&4.2.2, \(lqConnecting to the MySQL Server\(rq\&.

707

745

.RE

708

746

.sp

769

807

.sp -1

770

808

.IP \(bu 2.3

771

809

.\}

810

.\" mysqlbinlog: server-id-bits option

811

.\" server-id-bits option: mysqlbinlog

812

\fB\-\-server\-id\-bits=\fR\fB\fIN\fR\fR

813

.sp

814

Use only the first

815

\fIN\fR

816

bits of the

817

server_id

818

to identify the server\&. If the binary log was written by a

819

\fBmysqld\fR

820

with server\-id\-bits set to less than 32 and user data stored in the most significant bit, running

821

\fBmysqlbinlog\fR

822

with

823

\fB\-\-server\-id\-bits\fR

824

set to 32 enables this data to be seen\&.

825

.sp

826

This option was added in MySQL Cluster NDB 7\&.0\&.17 and MySQL Cluster NDB 7\&.1\&.6, and is supported only by the versions of

827

\fBmysqlbinlog\fR

828

supplied with these and later releases of MySQL Cluster\&.

829

.RE

830

.sp

831

.RS 4

832

.ie n \{\

833

\h'-04'\(bu\h'+03'\c

834

.\}

835

.el \{\

836

.sp -1

837

.IP \(bu 2.3

838

.\}

772

839

.\" mysqlbinlog: set-charset option

773

840

.\" set-charset option: mysqlbinlog

774

841

\fB\-\-set\-charset=\fR\fB\fIcharset_name\fR\fR

791

858

\fB\-\-short\-form\fR,

792

859

\fB\-s\fR

793

860

.sp

794

Display only the statements contained in the log, without any extra information\&.

861

Display only the statements contained in the log, without any extra information or row\-based events\&. This is for testing only, and should not be used in production systems\&.

795

862

.RE

796

863

.sp

797

864

.RS 4

1239

1306

FORMAT_DESCRIPTION_EVENT\&. The following table lists the possible type codes\&.

1240

1307

.TS

1241

1308

allbox tab(:);

1242

l l l

1243

l l l

1244

l l l

1245

l l l

1246

l l l

1247

l l l

1248

l l l

1249

l l l

1250

l l l

1251

l l l

1252

l l l

1253

l l l

1254

l l l

1255

l l l

1256

l l l

1257

l l l

1258

l l l

1259

l l l

1260

l l l

1261

l l l

1262

l l l

1263

l l l

1264

l l l

1265

l l l

1266

l l l

1267

l l l

1268

l l l

1269

l l l.

1309

lB lB lB.

1270

1310

1271

1311

Type

1272

1312

T}:T{

1274

1314

T}:T{

1275

1315

Meaning

1276

1316

1317

.T&

1318

l l l

1319

l l l

1320

l l l

1321

l l l

1322

l l l

1323

l l l

1324

l l l

1325

l l l

1326

l l l

1327

l l l

1328

l l l

1329

l l l

1330

l l l

1331

l l l

1332

l l l

1333

l l l

1334

l l l

1335

l l l

1336

l l l

1337

l l l

1338

l l l

1339

l l l

1340

l l l

1341

l l l

1342

l l l

1343

l l l

1344

l l l.

1277

1345

1278

1346

1279

1347

T}:T{

1537

1605

Flags: 16 flags\&. Currently, the following flags are used\&. The others are reserved for future use\&.

1538

1606

.TS

1539

1607

allbox tab(:);

1540

l l l

1541

l l l

1542

l l l

1543

l l l

1544

l l l.

1608

lB lB lB.

1545

1609

1546

1610

Flag

1547

1611

T}:T{

1549

1613

T}:T{

1550

1614

Meaning

1551

1615

1616

.T&

1617

l l l

1618

l l l

1619

l l l

1620

l l l.

1552

1621

1553

1622

1554

1623

T}:T{

1964

2033

.SH "COPYRIGHT"

1965

2034

.br

1966

2035

.PP

1967

2036

1968

2037

.PP

1969

2038

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

1970

2039

.PP

1972

2041

.PP

1973

2042

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

1974

2043

.sp

1975

.SH "NOTES"

1976

.IP " 1." 4

1977

Bug#42941

1978

.RS 4

1979

\%http://bugs.mysql.com/bug.php?id=42941

1980

.RE

1981

2044

.SH "SEE ALSO"

1982

2045

For more information, please refer to the MySQL Reference Manual,

1983

2046

which may already be installed locally and which is also available

Older »