#!/bin/bash
#The function of the script
# 1. mysqldump,backup kaliankeji database,backup path is /mysql_backup
# 2. delete backup befor 14 days
####################################
newbak=kaliankeji_`date +%Y%m%d`.dump
oldbak=kaliankeji_`date +%Y%m%d --date "-14 day"`.dump
echo
echo "########################################"
echo "---------------------------"
echo `date`
echo "---------------------------"
if [ -f $newbak ]
then
echo "the mysql backup file exists!"
else
/usr/bin/mysqldump -uroot -proot kaliankeji > /mysql_backup/$newbak
if [ $? -eq 0 ]
then
echo "The backup to complete and it is Successfull!"
else
echo "mysqldump Execute unsuccessfully,Please check the "
fi
fi
cd /mysql_backup
if [ -f $oldbak ]
then
rm -f $oldbak
if [ $? -eq 0 ]
then
echo "------------------------------"
echo "14 days before the backup file $oldbak has been deleted!"
fi
fi
echo "------------------------------"
echo "########################################"
echo
#The function of the script
# 1. mysqldump,backup kaliankeji database,backup path is /mysql_backup
# 2. delete backup befor 14 days
####################################
newbak=kaliankeji_`date +%Y%m%d`.dump
oldbak=kaliankeji_`date +%Y%m%d --date "-14 day"`.dump
echo
echo "########################################"
echo "---------------------------"
echo `date`
echo "---------------------------"
if [ -f $newbak ]
then
echo "the mysql backup file exists!"
else
/usr/bin/mysqldump -uroot -proot kaliankeji > /mysql_backup/$newbak
if [ $? -eq 0 ]
then
echo "The backup to complete and it is Successfull!"
else
echo "mysqldump Execute unsuccessfully,Please check the "
fi
fi
cd /mysql_backup
if [ -f $oldbak ]
then
rm -f $oldbak
if [ $? -eq 0 ]
then
echo "------------------------------"
echo "14 days before the backup file $oldbak has been deleted!"
fi
fi
echo "------------------------------"
echo "########################################"
echo
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29798713/viewspace-1376113/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
mysql 因主机名问题，初始化不正确
下一篇：
查找最消耗资源的SQL
请登录后发表评论
登录
全部评论
