当前位置: 首页
windows系统下利用备份和日志文件恢复数据库mysql信息2020-03-15 22:05:55.0windows系统下利用备份和日志文件恢复数据库信息:强调,日志只是编辑语句,如果最初的数据没有无解。 此恢复过程就是:原始数据+修改编辑语句重新执行一遍=完整数据。如果中间有错误语句,找到它的位置,跳过即可。 cmd中到处语句文件:sql或txt. mysqlbinlog --start-position=543228323 "D:mysql5.5mysql-5.5.60-winx64datamysql-bin.000022" > D: izhidaochu22.sql mysqlbinlog "D:mysql5.5mysql-5.5.60-winx64datamysql-bin.000023" > D: izhidaochu23.sql mysqlbinlog --stop-position=292463296 "D:mysql5.5mysql-5.5.60-winx64datamysql-bin.000024" > D: izhidaochu24-1.sql mysqlbinlog --start-position=292463536 "D:mysql5.5mysql-5.5.60-winx64datamysql-bin.000024" > D: izhidaochu24-2.sql mysqlbinlog --start-datetime="2020-03-13 21:20:00" "D:mysql5.5mysql-5.5.60-winx64datamysql-bin.000024" > D: izhidaochu24-2-1.txt 查询关键语句的位置: show binlog events in 'mysql-bin.000024' limit 277405,5G;//limit后第一个是row数,第二个是筛选出row的个数。 show binlog events in 'mysql-bin.000024'from pos点(一定要有具体点) limit 5G; *************************** 9. row *************************** Log_name: mysql-bin.000024 Pos: 292463228 Event_type: Query Server_id: 1 End_log_pos: 292463296 Info: BEGIN *************************** 10. row *************************** Log_name: mysql-bin.000024 Pos: 292463296 Event_type: Query Server_id: 1 End_log_pos: 292463509 Info: use `qfxs`; update xh_f_zhang set url='https://www.biquge5200.com/6 1_61790/141912391.html',zhang='绗簲鐧惧叚鍗佷簩绔?绁為拱锛侊紙绗簩鏇达紒锛?, cai_content=2
|