mysql的備份與還原

1、備份的BAT。獲得當前日期作為檔案名稱，到處資料後壓縮刪除源檔案

 

echo off&setlocal enabledelayedexpansion for /f "tokens=1-3 delims=-:/ " %%a in ("%date%") do (set Y=%%a&set M=%%b&set D=%%c&if "!M:~0,1!"=="0" set M=!M:~1!if "!D:~0,1!"=="0" set D=!D:~1!)set/a D-=1&if !D! leq 0 (set/a M-=1&if !M!==0 set/a Y-=1,M=12set/a "T=^!(M-2)","R=(^!(Y%%4)&^!^!(Y%%100))|^!(Y%%400)","C=^!(M-4)|^!(M-6)|^!(M-9)|^!(M-11)","D=T*(28+R)+C*30+(^!T&^!C)*31"+D)set M=0%M%&set D=0%D%set mydate=%Y%%M:~-2%%D:~-2%echo %mydate% SET BAK_FILE=MY_DBBAK_"%mydate%".SQL SET LOG_FILE=MY_DBBAK.log echo "%mydate%" 》 %LOG_FILE% mysqldump --default-character-set=utf8 -h192.168.1.1 -uroot -R -padmin --triggers --single-transaction -B dbname >%BAK_FILE% rar a %BAK_FILE%.rar %BAK_FILE%del %BAK_FILE%echo "%mydate%" 》 %LOG_FILE%echo "" 》 %LOG_FILE%2、匯入

 mysql -uroot -p111111 dbname < aa.sql