#!/bin/bash
PATH=$PATH:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin
export PATH
#Begin
DB_USER=root
DB_PASSWORD=passwd
#tmp
tmp=/tmp/tmp_sqllog
/usr/local/mysql/bin/mysql -u $DB_USER -p$DB_PASSWORD -e 'show binary logs' >> $tmp
num=`grep -v "Log_name" $tmp|awk '{print $1}'|sort -rn|head -n 1`
/usr/local/mysql/bin/mysql -u $DB_USER -p$DB_PASSWORD -e "purge binary logs to '$num' "
rm -rf $num