python（2.6适用）备份mysql数据库

最新推荐文章于 2024-11-09 00:15:00 发布

design321

最新推荐文章于 2024-11-09 00:15:00 发布

阅读量723

点赞数

分类专栏： python

python 专栏收录该内容

34 篇文章

订阅专栏

本文介绍了一个使用Python脚本实现的MySQL数据库备份自动化方案，包括创建目录、执行备份命令及记录日志等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://www.cnblogs.com/hzhida/archive/2012/08/02/2620525.html


#!/usr/bin/env python
import sys,os,time
mysql_usr='chenjuan'
mysql_pwd='123456'
mysql_db='news'
mysql_charset='utf8'
today='./backup/'
logs_path='Logs.txt'

def writeLogs(filename,contents):
    f=file(filename,'a')
    f.write(contents)
    f.close()

fname=today+os.sep+time.strftime('%H%M%S')+'.txt'

if not os.path.exists(today):
 Msg='-'*30+time.strftime('%Y-%m-%d,%H:%M:%S')+'-'*30+'n'
 if(os.mkdir(today))==None:
	Msg+='**succeed to create dir:'+today+'nn'
	writeLogs(logs_path,Msg)
 else:
	Msg+='!!create backup dir:'+today+'failed,check whether dir can write! nn'
	writeLogs(logs_path,Msg)
 #sys.exit()

cmd_dump='mysqldump -u%s -p%s %s > %s' %(mysql_usr,mysql_pwd,mysql_db,fname)

if os.system(cmd_dump)==0:
    writeLogs(logs_path,'database backup: '+fname+'\n')
else:
    writeLogs(logs_path,'database backup failed! \n')