Mysql ubuntu 定时备份

来源：互联网发布：免费电子期刊制作软件编辑：程序博客网时间：2024/06/14 06:10

Copy 高总

新建文件夹：db_backup

新建文件：backup.sh

#!/bin/bashcd /data/db_backupnow1=$(date +%F)now2=$(date +%F_%H_%M_%S)file1=${now2}_jlw_forum.sqlfile2=${now2}_jlw_mall.sqlfile3=${now2}_jlw_user.sqlecho $now1echo $now2echo $file1echo $file2echo $file3echo "" >> backup.logecho "### Start to backup: $now2" >> backup.logif [ ! -d $now1 ]; thenmkdir $now1echo "Create folder: $now1"echo "Create folder: $now1" >> backup.logficd $now1mysqldump -ujlw-forum -pcyhjd9abc309a -c --skip-extended-insert jlw_forum > $file1echo "backup: $file1" >> ../backup.logmysqldump -ujlw-mall -pahiicfcac414fg -c --skip-extended-insert jlw_mall > $file2echo "backup: $file2" >> ../backup.logmysqldump -ujlw-user -pxx0d99bet56 -c --skip-extended-insert jlw_user > $file3echo "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 restartubuntu@VM-0-4-ubuntu:/etc$ sudo service cron reload

阅读全文

0 0