mysql备份shell脚本

cron

50 0 * * *　rsync -avzP root@xxx.com:/home/mysql_data_backup   /home/my_site_backup/

mysql-backup.sh

#!/bin/bash

# 配置备份路径
basePath='/home/mysql_data_backup'

# 配置数据库
dataBase='test'

#path=$basePath/$(date +"%Y")/$(date +"%m")
path=$basePath
mkdir -p $path
#Now=$(date +"%Y-%m-%d_%H%M%S")
Now=$(date +"%w")
File=$path/$dataBase-$Now.sql
echo "Start backup...."

# 配置数据库
mysqldump --opt -uroot  -p123456 -Q $dataBase > $File

echo "Your Database Backup Successfully Completed"

#### cron
#  10 0 * * *  /bin/bash /home/shell/mysql-backup.sh
###