备份博客数据的小脚本

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()