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
评论回复