?????????????????????????????????????????????锟�??????????????MySQL?????????慰??????????纾琩elete???????????????????????????????????????????????????????????????????????????????????????????????
?????????
???????????????????????????????binlog?????????????????????????????????????SQL??????????binlog??????????????????????????
????????binlog2sql????????
???????????????MySQL server??????binlog???????????2???:
????[mysqld]
????server-id = 1
????log_bin = /var/log/mysql/mysql-bin.log
????max_binlog_size = 1000M
????binlog-format = row
?????????锌???binlog???????????????SQL??????????????????????????????????????MySQL??????????binlog??
?????????????????binlog2sql??binlog2sql???????????binlog??????????????????????????binlog?????????
????git clone https://github.com/danfengcao/binlog2sql.git
????pip install -r requirements.txt
????????????????????SQL???
???????????????test??tbl????????????????????????
????test??tbl?????????
????mysql> select * from tbl;
????+----+--------+---------------------+
????| id | name   | addtime             |
????+----+--------+---------------------+
????|  1 | 小??   | 2016-12-10 00:04:33 |
????|  2 | 小?   | 2016-12-10 00:04:48 |
????|  3 | 小??   | 2016-12-10 00:04:51 |
????|  4 | 小??   | 2016-12-10 00:04:56 |
????+----+--------+---------------------+
????4 rows in set (0.00 sec)
????mysql> delete from tbl;
????Query OK?? 4 rows affected (0.00 sec)
????tbl??????
????mysql> select * from tbl;
????Empty set (0.00 sec)
?????????????瑁�
????1?????mysql????????binlog???
????mysql> show master logs;
????+------------------+-----------+
????| Log_name         | File_size |
????+------------------+-----------+
????| mysql-bin.000046 |  12262268 |
????| mysql-bin.000047 |      3583 |
????+------------------+-----------+
????2???渭?binlog?????mysql-bin.000047?????????位?????SQL??binlog位??
????MySQL
????$ python binlog2sql/binlog2sql.py -h127.0.0.1 -P3306 -uadmin -p'admin' -dtest -ttbl --start-file='mysql-bin.000047'
?????????
????$ python binlog2sql/binlog2sql.py -h127.0.0.1 -P3306 -uadmin -p'admin' -dtest -ttbl --start-file='mysql-bin.000047'
?????????
????DELETE FROM `test`.`tbl` WHERE `addtime`='2016-12-10 00:04:33' AND `id`=1 AND `name`='小??' LIMIT 1; #start 3346 end 3556
????DELETE FROM `test`.`tbl` WHERE `addtime`='2016-12-10 00:04:48' AND `id`=2 AND `name`='小?' LIMIT 1; #start 3346 end 3556
????DELETE FROM `test`.`tbl` WHERE `addtime`='2016-12-10 00:04:51' AND `id`=3 AND `name`='小??' LIMIT 1; #start 3346 end 3556
????DELETE FROM `test`.`tbl` WHERE `addtime`='2016-12-10 00:04:56' AND `id`=4 AND `name`='小??' LIMIT 1; #start 3346 end 3556