把某一时段要恢复数据导出到sql文件,导出文件没;（分号）  查找替换

./mysqlbinlog --start-datetime='2019-02-25  20:42:00' --stop-datetime='2019-02-26  09:48:00' ../var/mysql-bin.00002* |grep 'je_task_order' >pre_task.sql

导入

mysql -uroot -pxxxxx

use dbname

source pre_task.sql

事先确保时间段之外的数据正确

ERROR 2006 (HY000) at line xx: MySQL server has gone away 解决方法 加大  

max_allowed_packet=16M