#!/bin/bash
#
# alte lxuls-bin.??? Dateien lschen
####################################
#
MYSQL="/usr/local/bin/mysql_sql -s localhost -u root -p logging"
#
cd /var/lib/mysql
BIN=`grep '^log-bin[ 	]*=' /etc/my.cnf | sed 's/log-bin[^=]*=[	 ]*//'`
if [ -z "$BIN" ]
 then
  echo "Kann Binlog nicht bestimmen."
  exit 1
fi
if [ `ls $BIN.[0-9]*[0-9] | wc -l` -gt 2 ]
 then
  BF=`basename $BIN`
  BD=`dirname $BIN`
  last=`find $BD -mmin +1440 -name "$BF.[0-9]*[0-9]" 2>/dev/null | sort | tail -1`
  if [ ! -z "$last" ]
   then
    bn=`basename $last`
    $MYSQL "purge master logs to '$bn'"
  fi
fi
