mysql打包备份数据到_mysql数据库备份脚本打包并删除几天前的备份数据

#!/bin/bash

# 备份MySQL数据

# 保存10天备份数据

currentpath=`dirname $0`

if [ ${currentpath} == '.' ];then

currentpath=`pwd`

fi

backup_path=/backup/mysql

suffix=`date "+%F"`

logfile=${currentpath}/logs/mysqlbacklog.log

mysql_user=root

mysql_password=xxxxx

mysqldump_prog=/usr/local/mysql/bin/mysqldump

mysql_sock=/tmp/mysql.sock

[ ! -d ${backup_path} ] && mkdir -p ${backup_path}

echo "==============================================" >> ${logfile}

echo "`date "+%F %H:%M:%S"` 开始备份MySQL数据" >> ${logfile}

cd ${backup_path}

${mysqldump_prog} -u${mysql_user} -p${mysql_password} -S ${mysql_sock} -A -B -x -F --master-data=2 -E -R --triggers |gzip >${backup_path}/all-${suffix}.sql.gz

if [ $? -ne 0 ];then

echo "`date "+%F %H:%M:%S"` 备份MySQL数据失败" >> ${logfile}

else

echo "`date "+%F %H:%M:%S"` 备份MySQL数据成功,备份文件名:${backup_path}/all-${suffix}.sql.gz" >> ${logfile}

fi

echo "`date "+%F %H:%M:%S"` MySQL数据备份结束" >> ${logfile}

echo "==============================================" >> ${logfile}

cd ${backup_path}

find ${backup_path} -mtime +10 -exec rm -f {} \; # 删除七天以前的备份数据

mysql数据库备份脚本打包并删除几天前的备份数据

基本就是上面的写法了.大神写的脚本!