1.下载安装binlog2sql
https://github.com/danfengcao/binlog2sql
安装命令:
shell> git clone https://github.com/danfengcao/binlog2sql.git && cd binlog2sql
shell> pip install -r requirements.txt
2.配置my.ini
server_id = 1
log_bin = mysql-bin.log #设置log文件保存路径,默认为mysql的data目录下
max_binlog_size = 512M #最大log
binlog_format = row
binlog_row_image = full
3.设置Path环境变量,增加mysql下bin路径
4.重新运行数据库
5.进行相关事务操作,然后测试log文件是否保存