linux 下mysql数据库的热备份

mysqlbak.sh

#!/bin/bash    
PATH=/usr/local/sbin:/usr/bin:/bin  
TMPBACKDIR=/tmp/mysqlblackup  
BACKDIR=/backup/mysql    
ROOTPASS=******  
mkdir -p $BACKDIR  
rm -rf $TMPBACKDIR  
mkdir  $TMPBACKDIR  
mysqlhotcopy "52leshan" -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 +5 |xargs rm -rf 

 备份52leshan这个数据库。删除5天以上的备份数据