so_brave 发表于 2012-02-04 11:04

基于linux系统下的MYSQL自动备份

基于linux系统下的MYSQL自动备份








编辑 脚本文件db_user="root"
db_passwd="123456"
db_host="localhost"
backup_dir="/usr/local/apache2/htdocs/backup"
time="$(date +"%Y%m%d%H%M")"
MYSQL="/usr/local/mysql/bin/mysql"
MYSQLDUMP="/usr/local/mysql/bin/mysqldump"
MKDIR="/bin/mkdir"
RM="/bin/rm"
MV="/bin/mv"
GZIP="/bin/gzip"
test ! -w $backup_dir && echo "Error: $backup_dir is un-writeable." && exit 0
test ! -d "$backup_dir/$time" && $MKDIR -p "$backup_dir/$time"
all_db="$($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse 'show databases')"

for db in $all_db
do
    $MYSQLDUMP "--default-character-set=gbk" -u $db_user -h $db_host -p$db_passwd $db | $GZIP -9 > "$backup_dir/$time/$db.gz"
done
    exit 0;
设置定时任务

使用crontab -e命令编辑定时任务列表15 3 * * * sh /usr/scripts/mysql_backup.sh表示每天凌晨3点15分执行该脚本进行数据库备份

小忻黑夜 发表于 2012-02-04 11:04

谢谢分享

Shell_HAT 发表于 2012-02-04 13:23

15 3 * * * sh /usr/scripts/mysql_backup.sh >/usr/scripts/mysql_backup.log 2>&1

lastfile 发表于 2012-02-04 15:20

收下收下
页: [1]
查看完整版本: 基于linux系统下的MYSQL自动备份