Python实现向s3共享存储上传和下载文件

转载于 2019-01-21 14:45:00 发布 · 170 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/liang545621/p/10298617.html

本文介绍了一种使用Python脚本自动备份MySQL数据库的方法，并将其上传到Amazon S3存储桶。通过调用boto库，实现与S3的连接，利用mysqldump工具进行数据库备份。

#!/usr/bin/env python
#-*- encoding: utf8 -*-

import boto
import boto.s3.connection
from boto.s3.key import Key
from datetime import datetime
import os
# Reference: https://blog.youkuaiyun.com/github_25679381/article/details/52943665

conn = boto.connect_s3(
            aws_access_key_id = 'xxxxx',
            aws_secret_access_key = 'xxxxx',
            host = 's3.xxxxx', is_secure = False,
            calling_format = boto.s3.connection.OrdinaryCallingFormat())

mytime = datetime.now().strftime('%Y%m%d_%H')
bucket = conn.get_bucket('xxxxx')    
k = Key(bucket)

filename = 'xxxxx'+ mytime +'.sql'

k.key = filename

os.system("mysqldump -h xxxxx -u xxxxx -pxxxxx --single-transaction xxxxx > "+filename)

print 'backup mysql dumpfile finished!'

# Download
#filename2 = 'xxxxx'
#k.get_contents_to_filename(filename2)


# Upload
k.set_contents_from_filename(filename)

print 'upload to S3 finished!'