linux下定时任务（crontab）备份数据库

1、将下面文件存入.sh脚本文件
2、将脚本文件加入linux定时任务运行，即可在服务器上对mysql进行备份。

#!/bin/sh 数据库备份文件，只备份7天的
cd /bak/mysql
Now=`date +%Y%m%d`
File="数据库名称-${Now}.sql"
#delete the same today backup file                
if [ -f /bak/mysql/$File ]; then
rm -rf /bak/mysql/$File
echo "${Now}: today 数据库名称 bak file had moved ${File}." >> bak.log
else
echo "${Now}: today 数据库名称 bak file not exist ${File}." >> bak.log
fi

# move backup file to old floder
mv 数据库名称-* /bak/old
echo "${Now}: Old 数据库名称 databases backup are moved to mysqlold floder." >> bak.log
#backup database sql 备份数据库
/usr/bin/mysqldump -uroot -p'数据库密码' 数据库名称 > $File

#delete 7 days sql 只保留七天内的sql
SevenDays=$(date -d -7day +%Y%m%d)
SevenFile="数据库名称-${SevenDays}.sql"
#echo "${Now}: sevenFile name is "$SevenFile >> bak.log
if [ -f /bak/old/$SevenFile ]; then
rm -rf /bak/old/$SevenFile
echo "${Now}: 7days ago 数据库名称 bak file had moved ${SevenFile}" >> bak.log
else
echo "${Now}: 7days ago 数据库名称 bak file not exist ${SevenFile}" >> bak.log
fi