mysql查看bin log 并恢复数据

# 查看bin log 库
show binary logs;

# 位置
show binlog events in 'mysql-bin.000007';

查看bin log

mysqlbinlog --start-position=4009 --stop-position=4183 --database=test_p -v /usr/local/mysql/log-bin/mysql-bin.000007 > /tmp/binlog_rec1.sql

恢复

mysql -u root -pDaxizi7724530! -v < /tmp/binlog_rec1.sql