数据库自动备份脚本


  1. 脚本mysqlbak.sh
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    #!/bin/bash
    tool=/usr/bin/mysqldump
    dd=`date +%Y%m%d`
    username=root
    password=123456
    database=db
    backup_count=2
    backup_dir=~/mysqlbackup
    # 创建备份目录
    mkdir -p $backup_dir
    #创建备份 mysqldump -u root -p123456 users > /root/mysqlbackup/users-$filename.sql
    $tool -u $username -p$password $database > $backup_dir/$database-$dd.sql
    #写备份日志
    echo "create $backup_dir/$database-$dd.sql" >> $backup_dir/action.log
    #找出需要删除的备份
    delfile=`ls -l -crt $backup_dir/*.sql | awk '{print $9 }' | head -1`
    #判断现在的备份数量是否大于$backup_count
    count=`ls -l -crt $backup_dir/*.sql | awk '{print $9 }' | wc -l`
    if [ $count -gt $backup_count ]
    then
    rm $delfile #删除最早生成的备份,只保留backup_count数量的备份
    #写删除文件日志
    echo "delete $delfile" >> $backup_dir/action.log
    fi
  2. 创建crontab
    1
    2
    3
    #早上5点执行脚本
    crontab -e
    0 5 * * * /absolute/path/to/mysqlbak.sh > /dev/null 2>&1 &
    大功告成!