redmineのdbをバックアップ
mysql_backup.sh
# !/bin/sh
dumpfile=/tmp/redmine_`date "+%Y%m%d%H%M"`.dump
find /tmp -mtime +14 -name '*_*.dump' -exec rm -f {} \; >/dev/null 2>&1
mysqldump --defaults-extra-file=/etc/redmine_my.cnf --single-transaction redmine > $dumpfile
exit 0
取得したdumpをwindowsサーバにアップロード
send_file_srv.bat
set DATE_NOW=%date:~0,4%%date:~5,2%%date:~8,2%
set TARGET_DIR=\\Foo\hoge\redmine\%DATE_NOW%
mkdir %TARGET_DIR%
cd "%~dp0%"
start "send_dump"
cscript send_file_srv.vbs
timeout 5
cp *.dump %TARGET_DIR%
del *.dump
pause
send_file_srv.vbs
set WshShell = WScript.CreateObject("WScript.Shell")
strScpCmd = "scp -P 4400 foo@hoge:/tmp/redmine_"+ Replace(Left(Now(),10), "/", "")+"*dump .~"
WshShell.AppActivate "send_dump"
WshShell.SendKeys strScpCmd
WScript.Sleep 10000
WshShell.SendKeys "PASSWORD~"
WScript.Sleep 1000
WshShell.SendKeys "exit~"