sql备份

#!/bin/sh
user='root'
pwd=''
host='localhost'
MYDATE=`date +%Y-%m-%d`
LASTMONTH=`date -d "$(date +%Y%m)01 last month" +%Y-%m`
#mysqldump -u$user -p$pwd -h$host --opt xyk_db --skip-comments | gzip > /home/mysql/xyk_db/xyk_db-$MYDATE.sql.gz
#mysqldump -u$user -p$pwd -h$host --opt xyk1_db --skip-comments | gzip > /home/mysql/xyk_db/xyk1_db-$MYDATE.sql.gz
mysqldump -u$user -p$pwd -h$host --opt v186_www --skip-comments | gzip > /home/mysql/v186_www/v186_www-$MYDATE.sql.gz
#mysqldump -u$user -p$pwd -h$host --opt wxapi --skip-comments | gzip > /home/mysql/wxapi/wxapi-$MYDATE.sql.gz
#删除上个月所有备份
rm -rf /home/mysql/v186_www/v186_www-$LASTMONTH-*
exit 0