用的单文件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("发送失败")
''' #!/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 '''
|