MySQL Knowledge summary (iv) binary log

1 definitions

The Bin-log log records all of the DDL and DML statements, but does not include the query statement, which is saved as an event and describes the process of changing the data, which plays an important role in recovering data from a disaster.

2 Open

MySQL default is no development bin-log log, first we need to open Bin-log log, modify in MY.CNF

[Mysqld]

Log_bin = Mysql-bin

Datadir=/var/lib/mysql//Specify data files to store directories, such as binary log files

viewing binary log files

Cd/var/lib/mysql

Ls

Since the log is stored in binary mode and cannot be read directly, it needs to be viewed using MySQL's own Mysqlbinlog tool.

Mysqlbinlog mysql-bin.000001

Reference Documentation:

Http://www.blogjava.net/dongbule/archive/2010/09/04/331050.html

MySQL Knowledge summary (iv) binary log