#!/bin/bash

HOSTNAME="localhost"
PORT="3326"
USERNAME="root"
PASSWD="123456"
BACKDIR=/back/mysql
dateDIR=`date +"%Y-%y-%m-%d"`
OUTPUT=MysqlBackUp-$dateDIR.tar.gz
test -e $BACKDIR/$OUTPUT
if [ $? -ne 0  ]; then
mkdir -p  $BACKDIR/$dateDIR > /dev/null
for i in `mysql -u$USERNAME -p$PASSWD -e "show databases" | grep -v "Database" | grep -v "information_schema" `
do 
   mysqldump -u$USERNAME -p$PASSWD --opt $i | gzip > $BACKDIR/$dateDIR/${i}_${dateDIR}.sql.gz > /dev/null 
   tar -zcvPf  $BACKDIR/$OUTPUT  $BACKDIR/$dateDIR >/dev/null
done
echo "###################LOG###########################" >>/var/log/messages
echo "$OUTPUT is backup !!!!!!!!"                      >>/var/log/messages
echo "###################LOG########################" >>/var/log/messages
 rm -rf $BACKDIR/$dateDIR
 
else 
 
     echo "$OUTPUT backup is exist !!!!!"
fi
find $BACKDIR -mtime +4 -exec rm -rf {} \;