binlog2sql 用法
使用场景:binlog2sql是根据mysql的binlog (要求格式是row)反解析出delete,update操作,对误操作数据进行还原。
pip install -r requirements.txt
安装:
# tar xvf binlog2sql.tar.gz
# cd binlog2sql/binlog2sql_dependencies/
# tar xvf setuptools-0.6c11.tar.gz
# cd setuptools-0.6c11
# python setup.py install
# cd ..
# tar xvf pip-9.0.1.tar.gz
# cd pip-9.0.1
# python setup.py install
# cd ..
# pip install *.whl mysql-replication-0.9.tar.gz
解析出标准SQL:
python /usr/local/binlog2sql/binlog2sql/binlog2sql.py -h 192.168.100.51 -P 3002 -umandb -pMYSQLroot123 -d test-t tb1 --start-file=mysql-bin.000005 --start-datetime="2018-06-14 16:00:00"