show binary logs; 看日志全部
mysqlbinlog --no-defaults --start-datetime='2016-03-10 00:00:00' --stop-datetime='2016-07-21 15:01:01' /var/lib/mysql/mysql-bin_device.000011 >> /tmp/log.txt找出日志还原并查看
