mysql 误删除该如何恢复

前言：恢复操作前提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、开始模拟恢复操作