抱歉,您的浏览器无法访问本站

本页面需要浏览器支持(启用)JavaScript


了解详情 >

用的单文件sq3比较好复制于是直接用邮件发送的方式来备份

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.application import MIMEApplication
import os,datetime
_user = "---"
_pwd = "---"
_to = "---"
today = datetime.date.today().strftime('%y%m%d')
msg = MIMEMultipart()
msg["Subject"] = today+'数据库备份'
msg["From"] = _user
msg["To"] = _to
part = MIMEText('这是'+ today + '份的数据文件')
msg.attach(part)
#---这是附件部分---
for name in os.listdir():
if "db.sqlite3" in name :
part = MIMEApplication(open(name,'rb').read())
part.add_header('Content-Disposition', 'attachment', filename=today+'.sqlite3')
msg.attach(part)
break
s = smtplib.SMTP("smtp.qq.com", timeout=60)
try:
s.login(_user, _pwd)
s.sendmail(_user, _to, msg.as_string())
s.close()
print("发送成功")
except:
print("发送失败")


# 同文件夹下发送邮件.sh内容
'''
#!/bin/bash
cd /home/sites/173.82.120.157/MasterYi_Django_blog&&python3 发送邮件.py


crontab -e
19 1 * * * sh /home/sites/173.82.120.157/MasterYi_Django_blog/发送邮件.sh
'''

评论