BINLOG導出SQL文件 C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqlbinlog binlogpath > sqlfilepath -d dbname -f --stop-datetime stopdatetime --start-datet ...
======================================================
BINLOG導出SQL文件
======================================================
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqlbinlog binlogpath > sqlfilepath -d dbname -f --stop-datetime stopdatetime --start-datetime startdatetime
-------------參數解釋----------------
binlogpath BINLOG完整路徑（D:\data_backup\mysql_binlog\bin-log.000013）
sqlfilepath 導出到SQL文件的完整路徑：（d:\a.13.11.sql）
stopdatetime BINLOG導出篩選結束時間：（2017/07/17T13:33:26）
startdatetime BINLOG導出篩選開始時間：（2017/07/17T09:43:02）
dbname BINLOG導出篩選數據名稱
======================================================
命令行執行SQL文件
======================================================
mysql -f -uroot -ppwd -Ddbname<file
---------- 參數解釋-------------
-f 忽略錯誤，繼續執行
-u 資料庫username
-p 數據pwd 特殊字元轉義符^
-D 執行文件的目標資料庫
file 執行的sql文件完整路徑
======================================================
另新啟一個BINLOG文件 MYSQL COMMAND 下執行
======================================================
flush logs;
======================================================
BAT 為MYSQL執行多個文件，並記錄完成時間日誌，有待優化為 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
