MYSQL利用二进制日志恢复数据

把二进制日志转成文本查看
mysqlbinlog E:\xampp\mysql\data\mysql_bin.000001 > E:\xampp\mysql\data\mysql_bin.000001.txt
mysqlbinlog E:\xampp\mysql\data\mysql_bin.000003 > E:\xampp\mysql\data\mysql_bin.000003.sql

COMMIT/*!*/;
# at 4414  (这个)
#170119 10:07:24 server id 1  end_log_pos 4501 CRC32 0xa3d2a8cc  Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1484791644/*!*/;
BEGIN

恢复到某个点,

mysqlbinlog --stop-position=4414 E:\xampp\mysql\data\mysql_bin.000001 | mysql -uroot -p

mysqlbinlog --stop-date='2015-11-23 11:50:00' E:\xampp\mysql\data\mysql_bin.000003 | mysql -uroot -p

恢复某一段间隔

mysqlbinlog --start-position=1840  --stop-position=3538 e:\mysql_bin.000255 | mysql -u root -p

mysqlbinlog --start-date='2015-11-23 11:51:00'  --stop-date='2015-11-23 11:51:00' E:\xampp\mysql\data\mysql_bin.000003 | mysql -uroot -p