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.写入周期任务就完成了