Enable MySQL binary log in Windows

Enable MySQL binary log in Windows

1. Enable binary log

Change my. ini

Find [mysqld] and enter the following command

 

# Enable binary logs

Server-id = 1

Log-bin = E:/mysqlbin/BINLOG. Log

Log-bin-Index = E:/mysqlbin/BINLOG. Index

 

Restart MySQL

 

Mysql> show variables like "log _ % ";

+ --------------------------------- + ---------------- +

| Variable_name | value |

+ --------------------------------- + ---------------- +

| Log_bin | on |

| Log_bin_trust_function_creators | off |

| Log_error |. \ ts17-113.err |

| Log_slave_updates | off |

| Log_slow_queries | off |

| Log_warnings | 1 |

+ --------------------------------- + ---------------- +

 

You can see that log_bin is enabled.

E:/mysqlbin/contains two files.

Binlog.000001

BINLOG. Index

 

2. View binary log files

Show binary logs;

Show Master logs;

 

3. Export log files

Mysqlbinlog-uroot-p e: \ mysqlbin \ binlog.000001> D: \ test. SQL

 

References

Start the binary log file in MySQL in window

Http://blog.csdn.net/uvyoaa/article/details/6550685

Demo of enabling binary logs in MySQL

Http://database.51cto.com/art/201006/204642.htm

[MySQL performance log analysis tool]

Http://hi.baidu.com/xhl_tips/blog/item/95de63dff2e68014495403b1.html

Turn: http://www.cnblogs.com/foxhengxing/archive/2011/07/04/2097509.html