bin转sql，使用https://github.com/danfengcao/binlog2sql，方便又快捷

直接访问https://github.com/danfengcao/binlog2sql，查看安装和使用方式。

mysql -uroot -pa448ad888774f7a8 app_suhuan3c_com

python binlog2sql.py -h127.0.0.1 -P3306 -uroot -p’a448ad888774f7a8′ -ddcsfc_sy_8dfishu –start-file=’mysql-bin.000314′ –start-datetime=’2019-11-15 18:22:30′ –stop-datetime=’2019-11-15 18:22:32′

宝塔恢复MYSQL二进制日志为SQL

yum install -y git

yum install -y python-pip

git clone https://github.com/michael-liumh/binlog2sql.git && cd binlog2sql && pip3 install -r requirements.txt