mysql、oracle定时备份

1、oracle定时备份

@echo off
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
set tm= %time:~1,1%%time:~3,2%
set da= %date:~0,4%%date:~5,2%%date:~8,2%

if not exist "%CD%\%da:~1,6%" md "%CD%\%da:~1,6%"

exp gwcs_test/gwcs@orcl file=.\%da:~1,6%\%da:~1,9%tm%tm:~1,5%.dmp log=.\%da:~1,6%\%da:~1,9%tm%tm:~1,5%exp.log direct=y recordlength=65535 owner=gwcs_test 
"C:\Program Files\WinRAR\Rar.exe" a -df -ep "%CD%\%da:~1,6%\%da:~1,9%tm%tm:~1,5%.rar" "%CD%\%da:~1,6%\%da:~1,9%tm%tm:~1,5%*.*"

 2、mysql定时备份

set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
md "c:\数据备份\%ymd%"
"c:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" --opt -q ldps -uroot -p123456 --set-charset=utf8 > c:\数据备份\%Ymd%\mysql.sql
echo Winrar loading...
"C:\Program Files\WinRAR\WinRAR.exe" a -ep1 -r -o+ -m5 -df "c:\数据备份\%Ymd%.rar" "c:\数据备份\%Ymd%"
echo OK!