mysqlbinlog

1、查看logbin状态：show variables log;               查看binlog日志列表/状态：show master logs/status;

2、刷新log日志文件：flush logs;                           重置binlog日志：reset master;

3、查看binlog日志事件：show binlog events in ‘binlog.000001’ [FROM pos][LIMIT [offset,] row_count] \G;

4、在binlog下cmd查看binlog：mysqlbinlog --base64-output=decode-rows -vv --start-position=293 binlog.000002

5、恢复：①mysqlbinlog --start-position=292 --stop-position=435 --database=hello mysql-bin.000006 | mysql -uroot -p密码 -v hello

               ②将数据恢复到在sql文件：mysqlbinlog --start-position=292 --stop-position=435 --database=hello mysql-bin.000006 >restore.sql                                   

                                                         再将sql文件执行恢复语句：mysql -uroot -p < restore.sql