前言:恢复操作前提MySQL 开启bin_log
1、查看是否开启bin_log
mysql> show variables like '%log_bin%';
+---------------------------------+--------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------+
| log_bin | ON |
| log_bin_basename | /var/lib/mysql/mysql-bin |
2、开始模拟恢复操作