背景
- 个人小站点用的云主机
- 数据必须备份
- 主从备份意味着花更多的钱（穷。。）
思路
- dump 整个database
- 将文件同步至百度云
- 定期执行
工具
- mysqldump
- bypt-百度云/百度网盘Python客户端
- crontab
方案
mysqldump
mysqldump dbname > /home/back/mysqldump/dbname_`date +%Y%m%d_%H%M%S`.sql
注意需要更改my.cnf：
[mysqldump]
user=<name>
password=<password>
python 代码
import os
import datetime
dbs = ['dbname1', 'dbname2']
def dump(dbname):
cmd = 'mysqldump %s > /home/back/mysqldump/%s_' % (dbname, dbname)
cmd += '`date +%Y%m%d_%H%M%S`.sql'
return os.system(cmd) == 0
def upload(dbname):
cmd = 'bypy upload /home/back/mysqldump/%s_' % dbname
cmd += '`date +%Y%m%d_%H%M%S`.sql'
return os.system(cmd) == 0
for db in dbs:
if not dump(db) or not upload(db):
print '%s faild to backup database=%s' % (datetime.datetime.now(), db)
else:
print '%s success backup database=%s' % (datetime.datetime.now(), db)
crontab
python /xxxx/workspace/scripts/backup.py >> /home/back/mysqldump/backup.log