《MYSQL LOGBIN 數(shù)據(jù)日志恢復(fù)數(shù)據(jù)庫(kù)隨筆》要點(diǎn)：
本文介紹了MYSQL LOGBIN 數(shù)據(jù)日志恢復(fù)數(shù)據(jù)庫(kù)隨筆，希望對(duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。
BINLOG導(dǎo)出SQL文件
======================================================
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqlbinlog binlogpath > sqlfilepath ?-d dbname -f --stop-datetime stopdatetime ?--start-datetime startdatetime
-------------參數(shù)解釋----------------
binlogpath BINLOG完整路徑(D:\data_backup\mysql_binlog\bin-log.000013)
sqlfilepath 導(dǎo)出到SQL文件的完整路徑：(d:\a.13.11.sql)
stopdatetime BINLOG導(dǎo)出篩選結(jié)束時(shí)間：(2017/07/17T13:33:26)
startdatetime BINLOG導(dǎo)出篩選開(kāi)始時(shí)間：(2017/07/17T09:43:02)
dbname BINLOG導(dǎo)出篩選數(shù)據(jù)名稱
?
======================================================
命令行執(zhí)行SQL文件
======================================================
mysql -f -uroot -ppwd -Ddbname<file
---------- 參數(shù)解釋-------------
-f 忽略錯(cuò)誤,繼續(xù)執(zhí)行
-u 數(shù)據(jù)庫(kù)username
-p 數(shù)據(jù)pwd 特殊字符轉(zhuǎn)義符^?
-D 執(zhí)行文件的目標(biāo)數(shù)據(jù)庫(kù)
file 執(zhí)行的sql文件完整路徑
?
======================================================
另新啟一個(gè)BINLOG文件 MYSQL COMMAND 下執(zhí)行
======================================================
flush logs;
?
?
?
======================================================
BAT 為MYSQL執(zhí)行多個(gè)文件,并記錄完成時(shí)間日志,有待優(yōu)化為 FOR
======================================================
@echo off?
mysql -uroot -ppwd -Ddbname<D:\cc\bin-log.000010.sql
set d=%date:~0,10%
set t=%time:~0,8%
echo %d%%t% bin-log.000010.sql execed >> d:\cc\result.txt
mysql -uroot -p1q2w3e4r5t^^Y^&U*I(O)P -Dleizuwenhuadb<D:\cc\bin-log.000011.sql
set d1=%date:~0,10%
set t1=%time:~0,8%
echo %d1%%t1% bin-log.000011.sql execed >> d:\cc\result.txt
mysql -uroot -p1q2w3e4r5t^^Y^&U*I(O)P -Dleizuwenhuadb<D:\cc\bin-log.000012.sql
set d2=%date:~0,10%
set t2=%time:~0,8%
echo %d2%%t2% bin-log.000012.sql execed >> d:\cc\result.txt
mysql -uroot -p1q2w3e4r5t^^Y^&U*I(O)P -Dleizuwenhuadb<D:\cc\bin-log.000013.sql
set d3=%date:~0,10%
set t3=%time:~0,8%
echo %d3%%t3% bin-log.000013.sql execed >> d:\cc\result.txt
echo %d3%%t3% all exec complate >> d:\cc\result.txt
pause
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.snjht.com/jiaocheng/5548.html
