Re: Mysql binlog: help needed

[Gautam Prashant]

Hi,

I found the cause. I was using the incorrect binary log. Below are the correct steps:

(1) create a db
(2) create table; insert records
(3) mysqldump -u root -p --single-transaction --master-data=2 --flush-logs gp1 > gp1.sql
(4) insert one more record. then drop table
(5) select now();
(6) restore last dump.
(7) mysqlbinlog --stop-datetime="2012-01-11 10:18:20" mysql-bin.000015 | mysql -u root -p

Note: the time given should be previous time before drop is fired. Also, the binary log should be the latest one.