@echo off
net stop mysql
xcopy "C:/Program Files/MySQL/MySQL Server 5.0/data/piaoyi/*.*" D:/db_backup/%date:~0,10%/ /y
net start mysql
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
C:/MySQL/bin/mysqldump --opt -u root --password=123456 bbs > D:/db_backup/bbs_%Ymd%.sql
@echo on
%date% 輸出net stop mysql
"C:/Program Files/WinRAR/WinRAR.exe" a -ag -k -r -s D:/db_backup/mysql_.rar "C:/Program Files/MySQL/MySQL Server 5.0/data/"
net start mysql
參數:a添加 -ag日期命名 -k鎖定 -r遞歸 -s固實壓縮。生成如 mysql_20130803004138.rar。
@echo off
set yy=%date:~0,4%
set mm=%date:~5,2%
set dd=%date:~8,2%
if /i %time:~0,2% lss 10 set hh=0%time:~1,1%
if /i %time:~0,2% geq 10 set hh=%time:~0,2%
set mn=%time:~3,2%
set ss=%time:~6,2%
set filename=%yy%%mm%%dd%_%hh%%mn%%ss%
"C:/Program Files (x86)/MySQL/MySQL Server 5.0/bin/mysqldump.exe" -uroot -pxxx --opt --default-character-set=utf8 -e --triggers -R --hex-blob --flush-logs -x DBNAME > C:/db_backup/DBNAME%filename%.sql
echo 導出完成
關鍵參數:-e擴展 INSERT、-R存儲過程、--hex-blob二進制十六進制、--flush-logs刷新 binlog(利於增量備份)、-x鎖所有表。
將 .bat 放入「控制面板 → 任務計劃」,設定每日執行時間(建議凌晨低峰期)。