Mysql数据库自动备份脚本

来源：互联网发布：mac版qq无法发送文件编辑：程序博客网时间：2024/05/14 00:34

原文：http://www.devnote.cn/article/55.html

测试于：MySQL 5.0.95 | CentOS 5.7

#!/bin/sh# backup single mysql database and keep newest 15 days backup files.# database informationdb="db1"db_username="root"db_password="123"db_host="localhost"# the directory for your backup file.backup_dir="/mnt/backup/"# check the directory for your backup is writeabletest ! -w $backup_dir && echo "Error: $backup_dir is un-writeable." && exit 0# make the directory for your backup if not existtest ! -d "$backup_dir" && mkdir "$backup_dir"# date format for backup file (dd.mm.yyyy)time="$(date +"%Y.%m.%d")"mysqldump -u$db_username -p$db_password -h $db_host $db | gzip -9 > "$backup_dir/$db-$time.gz"#delete the oldest backup 15 days agofind $backup_dir -name "$db-*.gz" -mtime +15 |xargs rm -rfexit 0;

查看crontab中的设置，每天清晨3点执行备份（设置时使用crontab -e）

0 0