ubuntu 自動備份 mysql db for MyISAM

Ubuntu 20.04.1 LTS (Focal Fossa)
回覆文章
leeyc
文章: 81
註冊時間: 2020年 10月 23日, 01:54

ubuntu 自動備份 mysql db for MyISAM

文章 leeyc »

nano backup_db.sh

#!/bin/bash
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin
export PATH
day=`date +%Y-%m-%d`
basedir="/web/bak"
#/etc/init.d/mysql.server stop
docker stop mysql55
cd /web/mydata
tar -zcf "$basedir"/centerdb."$day".tar.gz centerdb
#/etc/init.d/mysql.server start
docker start mysql55
find /web/bak -mtime +30 -exec rm -f {} ;
#service httpd restart
#week=`date +%u`
#if [ $week == 7 ];
#then
# reboot
#fi
exit 0

用root權限設定
# crontab -e
# m h dom mon dow command
10 1 * * * /web/backup_db.sh

用user權限設定
/web$ crontab -e
# m h dom mon dow command
*/30 * * * * rsync -avh /web/www/img/*.* /web/nas/imgbak
0 3 * * * rsync -avh /web/bak/*.* /web/nas/dbbak
*/60 * * * * curl http://192.168.1.88/centerhr/getWorkData.php
回覆文章