--binlog中解析的sql
[ binlog2sql-master]
# python binlog2sql/binlog2sql.py -h192.168.80.132 -P3306 -uflashback -pflashback -droidba -troidba --start-file=‘mysql-bin.000003‘ --start-datetime=‘2017-01-12 18:00:00‘ --stop-datetime=‘2017-01-12 18:30:00‘
INSERT INTO `roidba`.`roidba`(`
id
`, `name`) VALUES (1,
‘mysql‘
);
#start 239 end 413 time 2017-01-12 18:10:54
INSERT INTO `roidba`.`roidba`(`
id
`, `name`) VALUES (2,
‘oracle‘
);
#start 492 end 667 time 2017-01-12 18:11:00
INSERT INTO `roidba`.`roidba`(`
id
`, `name`) VALUES (3,
‘mariadb‘
);
#start 746 end 922 time 2017-01-12 18:11:08
DELETE FROM `roidba`.`roidba` WHERE `
id
`=1 AND `name`=
‘mysql‘
LIMIT 1;
#start 1001 end 1200 time 2017-01-12 18:11:14
DELETE FROM `roidba`.`roidba` WHERE `
id
`=2 AND `name`=
‘oracle‘
LIMIT 1;
#start 1001 end 1200 time 2017-01-12 18:11:14
DELETE FROM `roidba`.`roidba` WHERE `
id
`=3 AND `name`=
‘mariadb‘
LIMIT 1;
#start 1001 end 1200 time 2017-01-12 18:11:14
USE roidba;
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO
‘flashback‘
@
‘%‘
IDENTIFIED BY PASSWORD
‘*6DE874C277DDA35061BD526FB38B6A3C8B3A9254‘
;
USE roidba;
flush privileges;
来源: