2019獨角獸企業(yè)重金招聘Python工程師標(biāo)準(zhǔn)>>>

# coding:utf-8 import subprocess import smtplib from email.mime.text import MIMEText from email.header import Header from email.utils import parseaddr, formataddr databases=['db1','db2']def backup(database):commandfull="/usr/local/mysql/bin/mysqldump -u%s -p%s %s > %s.sql" %('root','sy2015',database,database)subprocess.call(commandfull, shell=True)def _format_addr(s):name,addr = parseaddr(s)return formataddr((Header(name, 'utf-8').encode(), addr.encode('utf-8') if isinstance(addr,unicode) else addr))def sendEMail():from_addr = "from@163.com"password = "pwd"smtp_server = "smtp.163.com"to_addr = "to@163.com"msg = MIMEText('數(shù)據(jù)庫備份成功!', 'plain', 'utf-8')msg['From'] = _format_addr(from_addr)msg['To'] = _format_addr(to_addr)msg['Subject'] = Header(u'數(shù)據(jù)庫備份信息', 'utf-8').encode()server = smtplib.SMTP(smtp_server, 25)server.set_debuglevel(1)server.login(from_addr, password)server.sendmail(from_addr, [to_addr], msg.as_string())server.quit()if __name__ == '__main__':for database in databases:backup(database) sendEMail()

轉(zhuǎn)載于:https://my.oschina.net/famiover/blog/672248

超強(qiáng)干貨來襲 云風(fēng)專訪：近40年碼齡，通宵達(dá)旦的技術(shù)人生

總結(jié)

以上是生活随笔為你收集整理的Python脚本备份数据库的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。