#!/bin/bash
db_user="root"
db_passwd="password"
db_name="nses"
#备份目录
backup_dir="/home/tanzhenjun/mysqldata"
backup_dir_old="/home/tanzhenjun/mysqldataold"
#进入备份目录将之前的移动到old目录
cd $backup_dir
echo "you are in bakmysql directory now"
mv nses* $backup_dir_old
echo "Old databases are moved to bakmysqlold folder"
#时间格式
time=$(date +"%Y-%m-%d")
#备份数量
count=`ls -l -crt $backup_dir_old/*.sql | awk '{print $9 }' | wc -l`
echo $count
#mysql 备份的命令,注意有空格和没有空格
mysqldump -u$db_user -p$db_passwd $db_name > "$backup_dir/$db_name"-"$time.sql"
echo "your database backup successfully completed"
#这里将7天之前的备份文件删掉
SevenDays=$(date -d -7day +"%Y-%m-%d")
if [ -f $backup_dir_old/$db_name-$SevenDays.sql -a $count -gt 5 ]
then
rm -rf $backup_dir_old/$db_name-$SevenDays.sql
echo "you have delete 7days ago bak sql file "
else
echo $db_name-$SevenDays.sql
echo "7days ago bak sql file not exist "
echo "bash complete"
fi
添加可执行权限
chmod u+x bkDatabaseName.sh
添加计划任务
执行命令:
这时就像使用vi编辑器一样,可以对计划任务进行编辑。
输入以下内容并保存: