[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