[問題] 請問怎麼寫Cron Jobs備份資料庫?
我是用000webhost
我想讓資料庫能夠定期自己備份
找到這篇文章
http://mrmo.cc/mousontech/1518
但是我照他所寫的方式改了
依然沒辦法成功備份
寫信問000webhost~他們回:
If you run cronjob using PHP command (like php -f
/home/username/public_html/file.php) and get no PHP errors, it means cronjob
might be executed without any problems and there is a problem with your
script.
意思是?是腳本有問題嗎?
可以請會腳本的看我改的哪裡有誤嗎?
----------------------------
#BASH Setting
WORKDIR=/home/a1667028/backup
BACKUPFILENAME=dbbackup_
FTPHOST=31.170.160.86
FTPUSER=a1667028
FTPPASS=*******
DBNAME=a1667028_movies
DBUSER=a1667028_yan
DBPASS=*******
#Program
cd $WORKDIR
stamp=`date +%Y%m%d_%H%M` #time stamp , format 20110107_1256
mysqldump -u$DBUSER -p$DBPASS --default-character-set=utf8 $DBNAME >
$BACKUPFILENAME$stamp.sql #dump sql file
#bp2 -z -f $BACKUPFILENAME_$stamp.sql #compress file ,bz2
gzip -v $BACKUPFILENAME$stamp.sql #compress file ,gz
ftp -inv $FTPHOST << EOF
user $FTPUSER $FTPPASS
cd /
binary
put $BACKUPFILENAME$stamp.sql.gz
bye
EOF
rm $BACKUPFILENAME$stamp.sql.gz #remove temp file
-------------------------------
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 125.225.3.201
推
02/18 13:53, , 1F
02/18 13:53, 1F
→
02/18 13:56, , 2F
02/18 13:56, 2F
推
02/20 04:16, , 3F
02/20 04:16, 3F
→
02/20 04:16, , 4F
02/20 04:16, 4F
→
02/20 21:51, , 5F
02/20 21:51, 5F