mysql5.7.44误删除数据后，使用binlog日志恢复

系统环境

#系统版本
# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
#数据库版本
# mysql -V
mysql  Ver 14.14 Distrib 5.7.44, for Linux (x86_64) using  EditLine wrapper

恢复前提

本文仅适合mysql数据库已经开启binlog日志的情况。
查看binlog是否开启

mysql> show variables like '%log_bin%';
+---------------------------------+--------------------------------+
| Variable_name                   | Value                          |
+---------------------------------+--------------------------------+
| log_bin                         | ON                             |
| log_bin_basename                | /var/lib/mysql/mysql-bin       |
| log_bin_index                   | /var/lib/mysql/mysql-bin.index |
| log_bin_trust_function_creators | OFF                            |
| log_bin_use_v1_row_events       | OFF                            |
| sql_log_bin                     | ON                             |
+---------------------------------+--------------------------------+
# ON 表示成功开启

查看binlog路径

mysql> show variables like '%datadir%';<