centos6.5 mysql备份_centos6.5 mysql定时备份

编辑sh文件写一个shell脚本 用来备份数据库

[root@localhost /]# vi mysql-backup.sh

#!bin/sh

db_user="用户名"

db_passwd="密码"

db_host="地址"

db_name="数据库名称"

# the directory for story your backup file.

backup_dir="/backup"

# date format for backup file (dd-mm-yyyy)

time="$(date +"%Y-%m-%d-%H-%M-%S")"

# mysql, mysqldump and some other bin's path

MYSQL="/usr/local/mysql/bin/mysql"

MYSQLDUMP="/usr/local/mysql/bin/mysqldump"

GZIP="/bin/gzip"

$MYSQLDUMP -u $db_user -h $db_host -p$db_passwd $db_name | $GZIP -9 > "$backup_dir/$db_name"_"$time.gz"

1.首先 chmod 700 MySQL-backup.sh                   // 只允许管理员运行此脚本

2. ./mysql-backup.sh   执行shell 看报错不报错

3. 建立目录

mkdir backup

4. crontab –e

5.弹出来一个vi编辑器 加入

# 00 03 * * * /mysql-backup.sh                  // 每天凌晨3点执行

6.crontab –ls 查看任务是否添加完毕