Wednesday, October 18, 2017

Daily backup script


[mysql@localhost]$ cat mysqldaily.sh
#!/bin/bash
# direcory initiations
BACKUP="/backup/"
ICR="/backup/ICR"
# Create non existing directories
[ ! -d $BACKUP ] && mkdir -p $BACKUP
[ ! -d $ICR ] && mkdir -p $ICR


dailyback(){
[ ! -d  $ICR/$(date +%F) ] && mkdir -p $ICR/$(date +%F)
    #cd /var/lib/mysql/
    find /var/lib/mysql/  -mmin -60 | grep ssgbin-log.* >> filelist
    for f in  $(cat filelist)
      do
        rsync -avh  "$f"  $ICR/$(date +%F)
      done
    rm -rf filelist
    #scp $ICR/$(date +%b)/$(date +%D)  backup@remoteserverip:/
    #rsync -avzhe  ssh $ICR/$(date +%b)  backup@remoteserverip:$ICR/ >> $RSYCLOG
    find /backup/ICR/*  -type d -ctime +10  -exec rm -rf  {} \;
 }
diskcheck(){
    rm output
    df -H | grep -vE '^Filesystem|tmpfs|cdrom' | awk '{ print $5 " " $1 }' | grep /dev/sda1 >> output
    DISK=$(cut -d'%' -f1 output)
    if [ $DISK -ge 6 ];
     then
       echo " Alert "
     fi
}
# Main function
main (){
           dailyback
#           diskcheck
}
main

No comments:

Post a Comment