用DropBox做VPS数据备份 - 全球主机交流论坛

# wget https://raw.github.com/andreafabrizi/Dropbox-Uploader/master/dropbox_uploader.sh
# chmod +x dropbox_uploader.sh
# ./dropbox_uploader.sh

复制代码

This is the first time you run this script.
1) Open the following URL in your Browser, and log in using your account: https://www2.dropbox.com/developers/apps
在浏览器中打开，https://www2.dropbox.com/developers/apps
2) Click on "Create App", then select "Dropbox API app"
点击"Create App"按钮，然后选择"Dropbox API app"
3) Select "Files and datastores"
选择"Files and datastores"选项
4) Now go on with the configuration, choosing the app permissions and access restrictions to your DropBox folder
现在去进行配置，选择这个app对你整个Dropbox文件夹的访问权限
5) Enter the "App Name" that you prefer (e.g. MyUploader113012919723169)
输入一个你喜欢的App名称
Now, click on the "Create app" button.
When your new App is successfully created, please type the
App Key, App Secret and the Permission type shown in the confirmation page:
# App key: xxxxxxxxxx
# App secret: xxxxxxxxx
# Permission type, App folder or Full Dropbox [a/f]: a
> App key is xxxxxxxxxx, App secret is xxxxxxxxxx and Access level is App Folder, it's ok? [y/n]y
> Token request... OK
Please open the following URL in your Browser, and allow Dropbox Uploader
to access your DropBox folder:
--> https://www2.dropbox.com/1/oauth/authorize?oauth_token=iP0TqrmjjKcAUfwW
Press enter when done...
> Access Token request... OK
Setup completed!

复制代码

wget http://vpsbar.qiniudn.com/backup.sh

复制代码

vim backup.sh

复制代码

#!/bin/bash
#
# when:2013/10/15
# who:http://blog.coocla.org
TODAY=`date -I` # 获取当前日期
BACKUP_LOG=/data/backup/backup_${TODAY}.log # 备份日志
Expire=`date -d -7day +"%Y-%m-%d"` # 获取7天前的日期
MYSQL_USER="root" # Mysql用户
MYSQL_PASS="rootpass" # Mysql密码
MYSQL_DB=('blog' 'yunxiaojia') # 要备份的数据库名
BACK_DIR=/data/backup # 备份存放的目录
Dropbox=/${TODAY} # Dropbox上创建的app存放目录，这里的根(/)是指app的根目录
WEB_DATA=/data/www/wwwroot # 网页文件目录
#Create Today BackupDirectory
if [ ! -d $BACK_DIR/$TODAY ];then
mkdir $BACK_DIR/$TODAY
fi
#Backup Mysql DB
echo "###############################################################" > $BACKUP_LOG
echo "Backup Mysql DB." >> $BACKUP_LOG
echo "Start Time : `date +%F" "%H:%M:%S`" >> $BACKUP_LOG
for db in ${MYSQL_DB[@]};do
/usr/bin/mysqldump -u$MYSQL_USER -p$MYSQL_PASS --skip-opt --add-drop-table --create-options -q -e --set-charset --routines --single-transaction --master-data=2 $db > ${TODAY}_${db}_full_back.sql --log-error=$BACKUP_LOG
done
tar zcf ${TODAY}_db_full_back.tar.gz *.sql
rm -f *.sql
mv ${TODAY}_db_full_back.tar.gz ${BACK_DIR}/${TODAY}/
echo "Stop Time : `date +%F" "%H:%M:%S`" >> $BACKUP_LOG
#Backup Website Data
echo "###############################################################" >> $BACKUP_LOG
echo "Backup Website Data." >> $BACKUP_LOG
echo "Start Time : `date +%F" "%H:%M:%S`" >> $BACKUP_LOG
cd $WEB_DATA
tar zcf ${TODAY}_web_full_back.tar.gz ./* && cd -
mv ${WEB_DATA}/${TODAY}_web_full_back.tar.gz ${BACK_DIR}/${TODAY}/
echo "Stop Time : `date +%F" "%H:%M:%S`" >> $BACKUP_LOG
#Upload Dropbox
echo "###############################################################" >> $BACKUP_LOG
echo "Upload backup." >> $BACKUP_LOG
echo "Start Time : `date +%F" "%H:%M:%S`" >> $BACKUP_LOG
/usr/local/sbin/dropbox_uploader.sh upload ${BACK_DIR}/${TODAY}/${TODAY}_db_full_back.tar.gz ${Dropbox}/${TODAY}_db_full_back.tar.gz >> $BACKUP_LOG
/usr/local/sbin/dropbox_uploader.sh upload ${BACK_DIR}/${TODAY}/${TODAY}_web_full_back.tar.gz ${Dropbox}/${TODAY}_web_full_back.tar.gz >> $BACKUP_LOG
echo "Stop Time : `date +%F" "%H:%M:%S`" >> $BACKUP_LOG
#Delete old data
echo "###############################################################" >> $BACKUP_LOG
echo "Delete expire data." >> $BACKUP_LOG
echo "Start Time : `date +%F" "%H:%M:%S`" >> $BACKUP_LOG
find ${BACK_DIR} -mtime +3 | xargs rm -rf
/usr/local/sbin/dropbox_uploader.sh delete /$Expire/ >> $BACKUP_LOG
echo "Stop Time : `date +%F" "%H:%M:%S`" >> $BACKUP_LOG

复制代码

59 23 * * * /bin/sh /usr/local/sbin/backup.sh > /dev/null 2>&1

复制代码