pip install yagmail
import os
import time
import datetime
import yagmail
DATETIME = time.strftime('%Y-%m-%d_%M:%H:%S')
BACKUPNAME = 'typecho_sql' + "-" + DATETIME + ".sql"
def backupDB():
#remove = 'rm -rf /home/backup/ *.sql' 自己做的BUG 哭着也要吃完!
remove = 'cd /home/backup/ && rm -rf *.sql'
os.system(remove)
time.sleep(2)
cmdString = 'mysqldump -u root -password. typecho > /home/backup/' + BACKUPNAME
os.system(cmdString)
def sendMail():
user = 'username@qq.com'
Email = yagmail.SMTP(user='username@163.com',password='nicai?',host='smtp.163.com',port='465')
Email.send(user,subject='Soo9s Blog Backup DBs',attachments=['/home/backup/'+ BACKUPNAME])
print "BACKUP AND SENDMAIL SUCCESS!"+DATETIME
if __name__ == '__main__':
backupDB()
sendMail()
前面忘记贴定时计划了。。 先启动crontab 没有的话需要安装一下 然后进入编辑模式 crontab -e 我定制的计划是每周周五15点备份,并发送到我的邮件
Tags: 备份脚本