定时每天备份mysql并定时删除上月备份脚本

每天定时备份,dbbak.sh

chmod 755 dbbak.sh

#!/bin/bash

year=`date   +%Y`
month=`date   +%m`
day=`date   +%d`
BACKDIR=/data/dbbak/$year$month/
ROOTPASS=123456
[ -d  $BACKDIR ] || mkdir -p $BACKDIR
rq=` date +%Y%m%d `
mysqldump my_db -u root -p$ROOTPASS -192.168.0.200 --opt| gzip > $BACKDIR/my_db$rq.sql.gz

每月删除上月备份，deldbbak.sh

chmod 755 deldbbak.sh

#!/bin/bash
year=`date   +%Y`
month=`date   +%m`
#day=`date   +%d`
month=`expr $month - 1` 
  if [ $month -eq 0 ]; then
 
     month=12
 
     day=31
 
     year=`expr $year - 1` 
 
  fi
 
  if [ $month -lt 10 ]; then
 
     pre=0 
 
   fi
 
 
BACKDIR=/data/golfdbbak/$year$pre$month
 

rm -rf $BACKDIR

定时配置

 crontab -e

0 3 * * * /data/dbbak/dbbak.sh
5 3 3 * * /data/dbbak/delbak.sh