#!/bin/bash
SQL_host=localhost
SQL_User=root
SQL_Passwd=123456
SQL_db=$(date +%Y%m%d) #database name
backup_path=/data/mysqlbak
file=$(date +%Y%m%d).tar.gz
#mysql_path=/usr/local/mysql/bin
cd $backup_path
if [ -d $backup_path/$(date +%Y%m%d) ]
then
cd $backup_path/$(date +%Y%m%d)
else mkdir $backup_path/$(date +%Y%m%d)
cd $backup_path/$(date +%Y%m%d)
fi
mysqldump -h $SQL_host -u $SQL_User -p$SQL_Passwd --add-drop-database --add-drop-table -f test > $SQL_db.sql --single-transation
sleep 3
tar -czf $file $SQL_db.sql
sleep 5
#path=/backup/
data=`date -d ' 8 day ago' +%Y%m%d`
rm -rf $backup_path/"$data"