root 身份登录到命令行
输入 crontab -e
按下 a 键进入到编辑模式
输入 */10 * * * * nohup /home/sqlbackup/sqlbackup.sh >> /home/sqlbackup/out.log 2>&1 &
同时按下 ctrl+c 退出编辑模式
按下 shift+: 输入 wq 退出 crontab
编写.sh 文件
currentpath=/home/sqlbackup
backpath="newfeeling"
function makedir(){
echo $(date "+%Y-%m-%d %H:%M:%S")
if [ -d $currentpath/$(date +%y%m%d) ]; then
echo "$(date +%y%m%d) is exsit"
else
mkdir $currentpath/$(date +%y%m%d)
echo "$(date +%y%m%d) is building"
fi
}
function backupsql(){
bakckpath=$currentpath/$(date +%y%m%d)
for i in $backpath;
do
backuptime=$(date +%y%m%d%H%M)
mysqldump -uroot -pysjz123456! $i>$bakckpath/$backuptime$i.sql
done
}
makedir
backupsql