mysql误删数据谁来拯救

`yum install libgnomeui-devel
gcc -w -g `pkg-config --cflags  glib-2.0` source/binlogParseGlib.c   -o binary/flashback usr/lib64/libglib-2.0.a -lrt yum install install glib2*`
复制

https://github.com/Meituan-Dianping/MyFlash/blob/master/doc/TestCase.md
CREATE TABLE `tb_test` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `nameBlob` longblob,   PRIMARY KEY (`id`) ) ENGINE=InnoDB；
复制

`./MyFlash/binary/flashback --binlogFileNames=/alidata/mysql/mybinlog.000022 --outBinlogFileNameBase=22delete.flashback`
复制

ERROR 1782 (HY000) at line 19: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.
复制

`mysqlbinlog -v -v --skip-gtids 22delete.flashback | sed 's@\/\*.*\*\/@@' |mysql -uroot -proot`
复制

--w_blob.py  写入blob




import sys
import pymysql
import os


path = "./"


fp = open("/alidata/PG01.jpg", 'rb')
img = fp.read()
fp.close()


database = pymysql.connect(host="localhost", user="root", passwd="root", db="qinxi")
cursor = database.cursor()
sql = "INSERT INTO tb_test (nameBlob) VALUES  (%s);"
args = (img)
cursor.execute(sql, args)
database.commit()
cursor.close()
database.close()


print("============")
print("Done! ")




--r_blob.py 读取blob


import pymysql as mdb
import sys


conn = mdb.connect(host='localhost',user='root',passwd='root',db='qinxi')
cursor = conn.cursor()
cursor.execute("SELECT nameBlob FROM tb_test LIMIT 1")
fout = open('PG333.jpg','wb')
fout.write(cursor.fetchone()[0])
fout.close()
cursor.close()
conn.close()






python binlog2sql.py -uroot -h10.200.6.53 -proot -B --start-file=mybinlog.000033 > 33.sql
复制