每天固定时间使用mysqldump 备份mysql数据。

#!/bin/bash

#每天早上4点， mysql备份数据 orangleliu

#chmod 700 backup.sh

#crontab -e

#0 4 * * * /home/erya/run/moniter/mysql_backup.sh

user="radius"

password=""

host="localhost"

db_name="radius"

#backup directory

base_dir="/home/backup"

backup_log="${base_dir}/mysql_backup.log"

backup_path=${base_dir}

#file info

date=$(date +"%Y-%m-%d")

filename=$backup_path/$db_name-$date.sql.gz

umask 177

#back up

mysqldump --user=$user --password=$password --host=$host $db_name | gzip > $filename

#Delete files older than 10 days

find $backup_path/* -mtime +10 -exec rm {} \;

echo "backup finished at $(date +'%Y-%m-%d %H:%M:%S')" >> "$backup_log"

參考

• Mysql-backup

版权声明：本文orangleliu(http://blog.csdn.net/orangleliu/)原创文章，文章转载申报。