使用mysqlbinlog 截图binlog日志

1、show master logs；show binary logs; 

mysql> show master logs;
+---------------+-----------+
| Log_name      | File_size |
+---------------+-----------+
| binlog.000001 |   5720095 |
| binlog.000002 |       177 |
| binlog.000003 |       154 |
+---------------+-----------+

2、show binlog events in 'binlog.000003';

mysql> show binlog events in 'binlog.000003';
+---------------+-----+----------------+-----------+-------------+---------------------------------------+
| Log_name      | Pos | Event_type     | Server_id | End_log_pos | Info                                  |
+---------------+-----+----------------+-----------+-------------+---------------------------------------+
| binlog.000003 |   4 | Format_desc    |        10 |         123 | Server ver: 5.7.26-log, Binlog ver: 4 |
| binlog.000003 | 123 | Previous_gtids |        10 |         154 |                                       |
+---------------+-----+----------------+-----------+-------------+---------------------------------------+
2 rows in set (0.00 sec)

3、根据pos 截图events事件

mysqlbinlog --start-position=  --stop-position= /data/3306/binlog/binlog.000003 > /tmp/huifu.sql

4、登录mysql 关闭binlog,保持登录状态

mysql> set sql_log_bin=off;
Query OK, 0 rows affected (0.00 sec)

mysql> 

5、恢复mysql -uroot -p -h -P -S   < /tmp/huifu.sql