mysql删除十天前数据脚本_备份mysql数据库且删除十五天前备份的shell脚本

#!/bin/bash

#备份mysql数据库

#filename：backup_mysql.sh

DBDIR=/data/mysql

BACKDIR=/data/bak/mysql

TIME=`date -d "today" +%F`

DB=$(ls -p $DBDIR | grep / |tr -d / | grep -Ev 'information_schema|performance_schema|mysql|test')

/etc/init.d/mysqld stop

if [ -d $BACKDIR ]

then

echo "OK!"

else

mkdir -p $BACKDIR

fi

cd $DBDIR

for i in $DB

do

tar czf $BACKDIR/$i\_db\_$TIME.tar.gz $i

done

/etc/init.d/mysqld start

find $BACKDIR -name "*.tar.gz" -type f -mtime +15 -exec rm {} \;  >/dev/null 2>&1