#!/bin/bash
PATH=/usr/local/sbin:/usr/bin:/bin
TMPBACKDIR=/tmp/mysqlblackup
BACKDIR=/backup/mysql
ROOTPASS=123456
mkdir -p $BACKDIR
rm -rf $TMPBACKDIR
mkdir $TMPBACKDIR
mysqlhotcopy "weibo" -u root -p $ROOTPASS $TMPBACKDIR | logger -t mysqlhotcopy
date=`date "+%Y.%m.%d"`
cd $TMPBACKDIR
tar czf $BACKDIR/mysql-$date.tar.gz ./
find $backupDir -name "*.gz" -mtime +3 |xargs rm -rf
完成mysqlback.sh 备份weibo这个数据库。删除3天以上的备份数据