mysql必须开启二进制日志,不开启无法恢复
状态的查看:mysql> show variables like '%log_bin%';
mysql> show variables like '%log_bin%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin | ON | //表示当前已开启二进制日志//
| log_bin_trust_function_creators | OFF |
| sql_log_bin | ON |
+---------------------------------+-------+
3 rows in set (0.00 sec)
找到mysql安装的mysqlbinlog命令的路径和二进制文件的路径指向下面的命令
[root@izwz987j bin]# /usr/local/mysql/bin/mysqlbinlog --base64-output=decode-rows -v /usr/local/mysql/var/mysql-bin.000095 > /root/binlog.sql 此命令是我把mysql的二进制日志转换为sql语句,通过查看sql操作找到被删除的语句进行恢复。