#!/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 {} \;
转载于:https://blog.51cto.com/lkernel/1144183