自动备份数据库

1.创建备份数据库所用的目录

mkdir /mnt/bak
mkdir /mnt/bak/bakmysql
mkdir /mnt/bak/bakmysqlold

2.创建一个后缀为.sh文件

 shujuku.sh

3.编辑内容

d /mnt/bak/bakmysql							//进入目录
echo "You are in bakmysql directory"					
mv bakmysql* /mnt/bak/bakmysqlold					//把前一天的数据移动到/mnt/bak/bakmysqlold下
echo "Old databases are moved to bakmysqlold folder"
Now=$(date +"%d-%m-%Y")
File=bakmysql-$Now.sql
mysqldump -u 数据库账号 -p'数据库密码' 数据库名字 > $File		//备份数据库并命名为今天的日期
echo "Your database backup successfully completed"
SevenDays=$(date -d -7day  +"%d-%m-%Y")
if [ -f /mnt/bak/bakmysqlold/bakmysql-$SevenDays.sql ]			//判断数据是否超过7天
then
rm -rf /mnt/bak/bakmysqlold/bakmysql-$SevenDays.sql			//超过则删除
echo "You have delete 7days ago bak file "
else
echo "7days ago bak file not exist "
fi

4.写入周期任务就完成了