MySQL自动备份

===============================================================
======第一个：shell+cron实现MySQL自动备份且自动删除N天前备份=====
===============================================================

#!/bin/sh
DUMP=/usr/local/mysql/bin/mysqldump
OUT_DIR=/home/liheyuan/xxx/backup/
LINUX_USER=liheyuan

DB_NAME=liheyuan
DB_USER=liheyuan
DB_PASS=xxx
#How much days backup most
DAYS=1

#Core of script
cd $OUT_DIR
DATE=`date +%Y_%m_%d`
OUT_SQL="$DATE.sql"
TAR_SQL="mysql_$DATE.tar.gz"
$DUMP --default-character-set=utf8 --opt -u$DB_USER -p$DB_PASS $DB_NAME > $OUT_SQL
tar -czf $TAR_SQL ./$OUT_SQL
rm $OUT_SQL
chown $DB_NAME:nobody ./$TAR_SQL
find ./ -name "mysql*" -type f -mtime +$DAYS -exec rm {} \;
+++++++++++++++++++++++++++++++++++++++++++++++++++++
mysqldump不用解释了吧，注意-uuser -ppass这样才可以，不能有空格。

find ./ -name “mysql*” -type f -mtime +$DAYS -exec rm {} \;