mysqlbinlog --start-position无法恢复数据

我在恢复数据时
发现mysqlbinlog --stop-position可以恢复数据，但是mysqlbinlog --start-position没有报错，却没有恢复数据，
然后去做测试

[root@haha ~]# mysql -uroot -p123456 -A
mysql> create database haha;
Query OK, 1 row affected (0.00 sec)

mysql> use haha;
Database changed

mysql> create table test(id int,name varchar(18));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into test values(1,"haha");
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+------+------+
| id   | name |
+------+------+
|    1 | haha |
+------+------+
1 rows in set (0.00 sec)

[root@haha ~]# mysqldump -uroot -p123456 --single-transaction --flush-logs -B haha > haha_db_$(date +%Y-%m-%d_%H:%M:%S).sql

[root@haha ~]# mysql -uroot -p123456 -A
mysql> use haha;
Database changed

mysql> insert into test values(100,"zz");
Query OK, 1 rows affected (0.00 sec)

mysql> delete from test where id=1;
Query OK, 1 row affected (0.00 sec)

mysql> insert into test values(101,"cc");
Query OK, 1 row affected (0.01 sec)

mysql> flush logs;
##就是这里，需要切割日志，--start-position才会成功恢复数据

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

[root@haha ~]#  mysql -uroot -p123456 haha < /opt/mysql_backup/haha_db_2021-03-09_20:06:00.sql
[root@haha ~]# mysql -uroot -p123456 -A
mysql> use haha;
Database changed

mysql> select * from test;
+------+------+
| id   | name |
+------+------+
|  1   | haha |
+------+------+
1 rows in set (0.00 sec)
[root@haha ~]# mysqlbinlog --stop-position=501 /data/mysql/log/mysql_bin.000003 | mysql -uroot -p123456
[root@haha ~]# mysql -uroot -p123456 -A
mysql> use haha;
Database changed

mysql> select * from test;
+------+------+
| id   | name |
+------+------+
|    1 | haha |
|  100 | zz   |
+------+------+
2 rows in set (0.00 sec)

[root@haha ~]# mysqlbinlog --start-position=681 /data/mysql/log/mysql_bin.000003 | mysql -uroot -p123456 -A
[root@haha ~]# mysql -uroot -p123456 -A
mysql> use haha;
Database changed

mysql> select * from test;
+------+------+
| id   | name |
+------+------+
|    1 | haha |
|  100 | zz   |
|  101 | cc   |
+------+------+
3 rows in set (0.00 sec)

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

需要恢复数据时，需要切割日志，正在使用的日志文件，无法使用–start-position恢复指定的数据