#!/bin/bash DATACFG=/etc/my.cnf DATADIR=`awk /^datadir/ $DATACFG|awk -F"=" '{print $2}'` DATAUSER=root DATAPASS=shiyiwen BINHOSTNAME=`hostname` DAY=$1 if [ ! $# == 1 ];then echo -e "\033[32m USAGE:$0 days\033[0m" echo -e "\033[32m Please setting days!\033[0m" sleep 2 exit 1 fi mysql -u$DATAUSER -p$DATAPASS -e "show master status;" > 1.txt BINLOGFILE=`awk 'NR==2 { print $1 }' 1.txt` rm -rf 1.txt if [ -z $BINLOGFILE ];then echo "binlog disable,exiting..." sleep 2 exit 1 fi if [[ ! "$BINLOGFILE" =~ ^$BINHOSTNAME ]];then echo "binlogname error,exiting..." sleep 2 exit 1 fi ### find $DATADIR -name "$BINHOSTNAME-bin.*" -mtime +$DAY |awk -F"/" ' { print $5 }'>1.txt #ls -l $DATADIR|awk '{ print $9 }'|awk '/^'$BINHOSTNAME'-bin\./{print $0}'>1.txt for i in `cat 1.txt` do if [[ "$i" != "$BINHOSTNAME-bin.index" && "$i" != "$BINLOGFILE" ]];then echo "rm -rf $DATADIR/$i" rm -rf $DATADIR/$i fi done rm -rf 1.txt