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
找出日志还原并查看
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
找出日志还原并查看
转载于:https://www.cnblogs.com/lordhaart/p/8023193.html