binlog-rollback.pl 在线恢复update 和delete不加条件误操作sql-10931853

mm111222

[root@git-server opt]# grep -i update /tmp/update.sql >/tmp/3.sql　　[root@git-server opt]# cat /tmp/3.sql
　　UPDATE `zixun3`.`zx_scores` SET `id`=15, `titles`='大将', `icon`=12, `integral`=29000, `isdefault`=1 WHERE `id`=15 AND `titles`='班长' AND `icon`=12 AND `integral`=29000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=12, `titles`='上将', `icon`=11, `integral`=24000, `isdefault`=1 WHERE `id`=12 AND `titles`='班长' AND `icon`=11 AND `integral`=24000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=11, `titles`='中将', `icon`=10, `integral`=19000, `isdefault`=1 WHERE `id`=11 AND `titles`='班长' AND `icon`=10 AND `integral`=19000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=10, `titles`='少将', `icon`=9, `integral`=14000, `isdefault`=1 WHERE `id`=10 AND `titles`='班长' AND `icon`=9 AND `integral`=14000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=9, `titles`='上校', `icon`=8, `integral`=9000, `isdefault`=1 WHERE `id`=9 AND `titles`='班长' AND `icon`=8 AND `integral`=9000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=8, `titles`='中校', `icon`=7, `integral`=6000, `isdefault`=1 WHERE `id`=8 AND `titles`='班长' AND `icon`=7 AND `integral`=6000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=7, `titles`='少校', `icon`=6, `integral`=5000, `isdefault`=1 WHERE `id`=7 AND `titles`='班长' AND `icon`=6 AND `integral`=5000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=6, `titles`='上尉', `icon`=5, `integral`=4000, `isdefault`=1 WHERE `id`=6 AND `titles`='班长' AND `icon`=5 AND `integral`=4000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=5, `titles`='中尉', `icon`=4, `integral`=3000, `isdefault`=1 WHERE `id`=5 AND `titles`='班长' AND `icon`=4 AND `integral`=3000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=4, `titles`='少尉', `icon`=3, `integral`=2000, `isdefault`=1 WHERE `id`=4 AND `titles`='班长' AND `icon`=3 AND `integral`=2000 AND `isdefault`=1;
　　UPDATE `zixun3`.`zx_scores` SET `id`=2, `titles`='列兵', `icon`=1, `integral`=0, `isdefault`=1 WHERE `id`=2 AND `titles`='班长' AND `icon`=1 AND `integral`=0 AND `isdefault`=1;
　　MySQL [zixun3]> source //tmp/3.sql ;
　　MySQL [zixun3]> select *  from zx_scores;
　　+----+--------+------+----------+-----------+

　　|>　　+----+--------+------+----------+-----------+
　　|  2 | 列兵   |    1 |        0 |         1 |
　　|  3 | 班长   |    2 |     1000 |         1 |
　　|  4 | 少尉   |    3 |     2000 |         1 |
　　|  5 | 中尉   |    4 |     3000 |         1 |
　　|  6 | 上尉   |    5 |     4000 |         1 |
　　|  7 | 少校   |    6 |     5000 |         1 |
　　|  8 | 中校   |    7 |     6000 |         1 |
　　|  9 | 上校   |    8 |     9000 |         1 |
　　| 10 | 少将   |    9 |    14000 |         1 |
　　| 11 | 中将   |   10 |    19000 |         1 |
　　| 12 | 上将   |   11 |    24000 |         1 |
　　| 15 | 大将   |   12 |    29000 |         1 |
　　+----+--------+------+----------+-----------+
　　12 rows in set (0.00 sec)