Mysql ubuntu 定时备份

Copy 高总

新建文件夹：db_backup

新建文件：backup.sh

#!/bin/bash
cd /data/db_backup
now1=$(date +%F)
now2=$(date +%F_%H_%M_%S)
file1=${now2}_jlw_forum.sql
file2=${now2}_jlw_mall.sql
file3=${now2}_jlw_user.sql
echo $now1
echo $now2
echo $file1
echo $file2
echo $file3
echo "" >> backup.log
echo "### Start to backup: $now2" >> backup.log
if [ ! -d $now1 ]; then
mkdir $now1
echo "Create folder: $now1"
echo "Create folder: $now1" >> backup.log
fi
cd $now1
mysqldump -ujlw-forum -pcyhjd9abc309a -c --skip-extended-insert jlw_forum > $file1
echo "backup: $file1" >> ../backup.log
mysqldump -ujlw-mall -pahiicfcac414fg -c --skip-extended-insert jlw_mall > $file2
echo "backup: $file2" >> ../backup.log
mysqldump -ujlw-user -pxx0d99bet56 -c --skip-extended-insert jlw_user > $file3
echo "backup: $file3" >> ../backup.log

进入etc目录

sudo vim crontab

添加

5 0 * * * jlw_user /data/db_backup/backup.sh

然后执行

ubuntu@VM-0-4-ubuntu:/etc$ sudo service cron restart
ubuntu@VM-0-4-ubuntu:/etc$ sudo service cron reload