[mysql]每日备份shell脚本

#每天早上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

版权声明：本文为博主原创文章，未经博主允许不得转载。

[mysql]每日备份shell脚本

标签：数据   shell   crontab   mysql   backup