mysql自動(dòng)備份Shell腳本，具體代碼如下：
#!/bin/sh
#program:
# backup the mysql
#history:
#2013/08/17 yubinhong first release
read -p "請(qǐng)輸入要備份數(shù)據(jù)庫(kù)的個(gè)數(shù)：" n
for i in $(seq 1 $n)
do
read -p "請(qǐng)輸入第$i個(gè)數(shù)據(jù)庫(kù)：" database
time=$(date +%Y%m%d)
mysqldump -uroot -p123456 $database > $database$time.sql
done
echo "備份完成！"