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 查看任务是否添加完毕