windows下如何對mysql進行整褲備份

標籤：

通常情況下備份一個資料庫，直接單褲備份即可，更完善一點的會要求做到定時單褲備份。然而很多時候又由於褲執行個體是在太多，這樣會導致備份非常耗時，因而有時候需要對整個資料庫應用進行備份。那麼在windows下如何做到對整個應用做定時備份呢？

1、批處理備份指令碼（注意修改指令碼裡面的變數）

@echo off & setlocal ENABLEEXTENSIONS ::日期set TODAY=%date:~0,4%%date:~5,2%%date:~8,2%::來源程式所在目錄set DATAPATH=E:\bak\data\*::備份目錄set BAKPATH=E:\webInfobackup::備份名稱首碼set BAKNAME=mg3MyData::+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++::+++++++++此目錄為備份目錄，壓縮後會刪除，修改時務必注意++++++++set SRCPATH=%BAKPATH%\%BAKNAME%%TODAY%::+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++call :Date2Day %date:~0,10% sdaysset /a sdays-=7call :Day2Date %sdays% difdateecho start bauckup mysql %date:~0,4%-%date:~5,2%-%date:~8,2% %time:~0,2%:%time:~3,2%:%time:~6,2% >>log.log::關閉mysql服務net stop mysql::複製data目錄xcopy %DATAPATH% %SRCPATH%\ /e /y::開啟mysql服務net start mysqlecho bauckup mysql finish %date:~0,4%-%date:~5,2%-%date:~8,2% %time:~0,2%:%time:~3,2%:%time:~6,2% >>log.log::壓縮資料庫檔案並刪除"C:\Program Files\WinRAR\WinRAR.exe" a -r -ep2 -ibck -inul -df -t %SRCPATH%.rar %SRCPATH%echo compress mysql data finish %date:~0,4%-%date:~5,2%-%date:~8,2% %time:~0,2%:%time:~3,2%:%time:~6,2% >>log.log::++++++++++++++++++刪除目錄++++++++++++++rd /q /s %SRCPATH% ::++++++++++++++++++刪除目錄++++++++++++++::刪除N天前備份檔案for /r %BAKPATH% %%f in (%BAKNAME%*.rar) do if "%%~tf" LEQ "%difdate%" del "%%f"goto:EOF exit:Date2Daysetlocal ENABLEEXTENSIONS for /f "tokens=1-3 delims=/-, " %%a in (‘echo/%1‘) do (   set yy=%%a & set mm=%%b & set dd=%%c )set /a dd=100%dd%%%100,mm=100%mm%%%100 set /a z=14-mm,z/=12,y=yy+4800-z,m=mm+12*z-3,j=153*m+2 set /a j=j/5+dd+y*365+y/4-y/100+y/400-2472633endlocal&set %2=%j%&goto :EOF :Day2Datesetlocal ENABLEEXTENSIONS set /a i=%1,a=i+2472632,b=4*a+3,b/=146097,c=-b*146097,c/=4,c+=a set /a d=4*c+3,d/=1461,e=-1461*d,e/=4,e+=c,m=5*e+2,m/=153,dd=153*m+2,dd/=5 set /a dd=-dd+e+1,mm=-m/10,mm*=12,mm+=m+3,yy=b*100+d-4800+m/10 (if %mm% LSS 10 set mm=0%mm%)&(if %dd% LSS 10 set dd=0%dd%) endlocal&set %2=%yy%%mm%%dd%&goto :EOF 

2、建立任務計劃

 不懂的可以GG一下，在此不詳細介紹。

windows下如何對mysql進行整褲備份