Mysqlデータベース自動バックアップスクリプト(windows and linux)

Windowsスクリプト:

@echo off
echo          ...
echo        !!
set hh=%time:~0,2%
if /i %hh% LSS 10 (set hh=0%time:~1,1%)
mysqldump -hlocalhost -uroot -proot travel_yninfo> travel_yninfo_com-%date:~0,4%%date:~5,2%%date:~8,2%-%hh%%time:~3,2%%time:~6,2%%time:~9,2%.sql
echo          travel_yninfo_com-%date:~0,4%%date:~5,2%%date:~8,2%-%hh%%time:~3,2%%time:~6,2%%time:~9,2%.sql！
echo. & pause

Linuxスクリプト(複数のデータベースバックアップをサポート):

#!/bin/bash
#Powered by James 2009-7-31
date=`date -d "%m"date -d today +"%Y-%m-%d-%H:%M"`
echo $date
db_array=(yntrip jsprun encounterYN)
lenArray=${#db_array[@]}
i=0
while [ $i -lt $lenArray ]
do
echo ${db_array[$i]}
mysqldump -uroot -hlocalhost -proot --default-character-set=utf8 --opt --extended-insert=false --triggers -R --hex-blob -x ${db_array[$i]} > /home/www/database/${db_array[$i]}-$date.sql;
let i++
done
#tar cvzf /home/www/database/mysql-data-$date.tar.gz /home/www/database/*$date.sql
echo "$date-database backup complete" >> backup.log
exit