MySQL脚本自动备份

#!/bin/bash
basebackup=/root/mpp/backup_daily/database
time=$(date '+%Y%m%d%H%M%S ')
dbUser=root
dbPwd=123456
dbName=db1
dbName2=db2
dbBackUpName=db1.sql
dbBackUpName2=db2.sql
rm -rf $basebackup/$time
mkdir $basebackup/$time
cd $basebackup/$time
touch $dbBackUpName
mysqldump $dbName --user=$dbUser --password=$dbPwd>$dbBackUpName
touch $dbBackUpName2
mysqldump $dbName2 --user=$dbUser --password=$dbPwd>$dbBackUpName2

或

mysqldump $dbName2 --user=$dbUser --password=$dbPwd | gzip>$dbBackUpName2