宁波网站建,如何判断网站是用织梦做的,如何自己做网站发布到服务器上面,普通电脑可以做网站服务器传统解法用全量备份重搭实例#xff0c;再利用增量binlog备份#xff0c;恢复到误操作之前的状态。然后跳过误操作的SQL#xff0c;再继续应用binlog。此法费时费力#xff0c;不值得再推荐。利用binlog2sql快速闪回首先#xff0c;确认你的MySQL server开启了binlog…传统解法用全量备份重搭实例再利用增量binlog备份恢复到误操作之前的状态。然后跳过误操作的SQL再继续应用binlog。此法费时费力不值得再推荐。利用binlog2sql快速闪回首先确认你的MySQL server开启了binlog设置了以下参数:[mysqld]server-id1log_bin/var/log/mysql/mysql-bin.logmax_binlog_size1000Mbinlog-formatrow如果没有开启binlog也没有预先生成回滚SQL那真的无法快速恢复数据了。对存放重要业务数据的MySQL强烈建议开启binlog。随后安装开源工具binlog2sql。binlog2sql是一款简单易用的binlog解析工具其中一个功能就是利用binlog进行闪回。gitclonehttps://github.com/danfengcao/binlog2sql.gitpipinstall-rrequirements.txt然后我们就可以生成回滚SQL了。背景误删了test库tbl表整张表的数据需要紧急回滚。test库tbl表原有数据mysqlselect*fromtbl;---------------------------------|id|name|addtime|---------------------------------|1|小赵|2016-12-1000:04:33||2|小钱|2016-12-1000:04:48||3|小孙|2016-12-1000:04:51||4|小李|2016-12-1000:04:56|---------------------------------4rowsinset(0.00sec)mysqldeletefromtbl;QueryOK,4rowsaffected(0.00sec)tbl表被清空mysqlselect*fromtbl;Emptyset(0.00sec)恢复数据步骤登录mysql查看目前的binlog文件mysqlshowmaster logs;-----------------------------|Log_name|File_size|-----------------------------|mysql-bin.000046|12262268||mysql-bin.000047|3583|-----------------------------最新的binlog文件是mysql-bin.000047我们再定位误操作SQL的binlog位置$pythonbinlog2sql/binlog2sql.py-h127.0.0.1-P3306-uadmin-padmin-dtest-ttbl--start-filemysql-bin.000047输出DELETEFROMtest.tblWHEREaddtime2016-12-10 00:04:33ANDid1ANDname小赵LIMIT1;#start 3346 end 3556DELETEFROMtest.tblWHEREaddtime2016-12-10 00:04:48ANDid2ANDname小钱LIMIT1;#start 3346 end 3556DELETEFROMtest.tblWHEREaddtime2016-12-10 00:04:51ANDid3ANDname小孙LIMIT1;#start 3346 end 3556DELETEFROMtest.tblWHEREaddtime2016-12-10 00:04:56ANDid4ANDname小李LIMIT1;#start 3346 end 3556生成回滚sql并检查回滚sql是否正确$pythonbinlog2sql/binlog2sql.py-h127.0.0.1-P3306-uadmin-padmin-dtest-ttbl--start-filemysql-bin.000047--start-pos3346--end-pos3556-B输出INSERTINTOtest.tbl(addtime,id,name)VALUES(2016-12-10 00:04:56,4,小李);#start 3346 end 3556INSERTINTOtest.tbl(addtime,id,name)VALUES(2016-12-10 00:04:51,3,小孙);#start 3346 end 3556INSERTINTOtest.tbl(addtime,id,name)VALUES(2016-12-10 00:04:48,2,小钱);#start 3346 end 3556INSERTINTOtest.tbl(addtime,id,name)VALUES(2016-12-10 00:04:33,1,小赵);#start 3346 end 3556确认回滚sql正确执行回滚语句。登录mysql确认数据回滚成功。$pythonbinlog2sql.py-h127.0.0.1-P3306-uadmin-padmin-dtest-ttbl--start-filemysql-bin.000047--start-pos3346--end-pos3556-B|mysql-h127.0.0.1-P3306-uadmin-padminmysqlselect*fromtbl;---------------------------------|id|name|addtime|---------------------------------|1|小赵|2016-12-1000:04:33||2|小钱|2016-12-1000:04:48||3|小孙|2016-12-1000:04:51||4|小李|2016-12-1000:04:56|---------------------------------软件测试免费视频观看链接https://ke.qq.com/course/159919#tuinba4122松勤网:www.songqinnet.com
