log_bin.txt

windows 系统下安装的mysql 
在 mysql 的my.ini 文件中

[msyqld] 
server_id=1
log_bin = mysql-bin
binlog_format = ROW
max_binlog_size = 1000M
expire_logs_days = 30



下载binlog2ql地址:
使用git bash：
git clone https://github.com/danfengcao/binlog2sql.git
安装pip
pip instal -



git bash 执行 
python binlog2sql/binlog2sql/binlog2sql.py  -u root -p root -d test -t studtent --start-file mysql-bin-000001
python binlog2sql/binlog2sql/binlog2sql.py  -u 数据库用户名 -p 密码 -d 库名 -t 表名 --start-file 要回滚动的版本

确认sql 
python binlog2sql/binlog2sql.py -h127.0.0.1 -P3306 -uroot -p'root' -dtest -t studtent --start-file='mysql-bin.000001' --start-pos=497 --end-pos=690 -B | mysql -h127.0.0.1 -P3306 -uroot -p'root'


跳转到存放binlog2sql文件下