感谢群里面的人们,如此热情。
指定时间,指定数据库
[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文件,数据再次重现