MySQL备份

#!/bin/sh
#/home/mysql_bakup.sh 
#chmod +x /home/mysql_bakup.sh
#vi /etc/crontab
#0 0 * * * root /home/mysql_bakup.sh 
#service crond restart
#请根据实际情况修改
#---------------------------------------
#备份路径
BAK_PATH=/home/backup/shucheng/mysql
DB_HOST=192.168.15.165
DB_NAME=shuchengex8
DB_USER=root
DB_PASS=Lonsun0717
#-------------------------------------

V_TIME=` date +%Y%m%d%H%M%S `
#如果目录不存在,则创建
if [ ! -d $BAK_PATH ];then
  mkdir -p $BAK_PATH
fi


#cd /usr/local/bin 
#wget http://yun.lonsun.cn/pub/centos/mysqldump
#chmod +x /usr/local/bin/mysqldump
/usr/local/bin/mysqldump -h$DB_HOST -u$DB_USER -p$DB_PASS $DB_NAME | gzip > $BAK_PATH/$DB_NAME-$V_TIME.sql.gz

#删除过期的数据和日志文件，保留7天
find $BAK_PATH -name "*.sql.gz" -type f -mtime +15 -exec rm -rf {} \;