mysql/mariadb10.x 恢复数据 binlog

感谢群里面的人们，如此热情。

指定时间，指定数据库

[root@iZwz9gd3xwhccp0zesp6njZ bin]# /usr/bin/mysqlbinlog --start-datetime='2016-10-23 01:00:00' --stop-datetime='2016-10-24 01:00:00' --database=test /dtd/data/dbdata_3306/master-bin.000013 > /dtd/backup/test13.sql
[root@iZwz9gd3xwhccp0zesp6njZ bin]# /usr/bin/mysqlbinlog --start-datetime='2016-10-23 01:00:00' --stop-datetime='2016-10-24 01:00:00' --database=heke10007 /dtd/data/dbdata_3306/master-bin.000013 > /dtd/backup/jeke10007.sql
[root@iZwz9gd3xwhccp0zesp6njZ bin]# /usr/bin/mysqlbinlog --start-datetime='2016-10-23 01:00:00' --stop-datetime='2016-10-24 01:00:00' --database=heke10007 /dtd/data/dbdata_3306/master-bin.000013 > /dtd/backup/heke10007.sql
[root@iZwz9gd3xwhccp0zesp6njZ bin]# /usr/bin/mysqlbinlog --start-datetime='2016-10-23 01:00:00' --stop-datetime='2016-10-24 01:00:00' --database=heke10007 /dtd/data/dbdata_3306/master-bin.000* > /dtd/backup/heke10007.sql
[root@iZwz9gd3xwhccp0zesp6njZ bin]# /usr/bin/mysqlbinlog --start-datetime='2016-10-17 01:00:00' --stop-datetime='2016-10-24 01:00:00' --database=heke10007 /dtd/data/dbdata_3306/master-bin.000* > /dtd/backup/heke10007.sql

完美，perfect

然后，直接导入sql文件，数据再次重现