Python基础学习九 数据库备份 

 1 class BakDb(object):
 2     def __init__(self,ip,username,passwd,port=3306,path=r'C:\Users\BJQT\Desktop\data_back'):
 3         self.ip = ip
 4         self.username = username
 5         self.passwd = passwd
 6         self.port = port
 7         self.path = path
 8         self.path_exist()
 9         self.bak_db()
10 
11     def path_exist(self):
12         if not os.path.isdir(self.path): #判断路径是否存在，不存在就创建
13             os.mkdir(self.path)
14 
15     def bak_db(self):
16         # mysqldump - u%s - p%s -P%s -h%s - A > XXX.sql
17         filename = str(datetime.date.today())+'.sql'
18         abs_file = os.path.join(self.path,filename) #变成绝对路径
19         # 路径不要有空格，否则SQL文件为空  C:\mysqldump.exe
20         command =r'''
21         C:\mysqldump.exe -u{username} -p{passwd} -P{port} -h{ip} -A > {filename}
22 
23         '''.format(username = self.username,
24                     passwd = self.passwd,
25                     port= self.port,
26                     filename = abs_file,
27                     ip = self.ip)
28         os.system(command)
29         print('done!数据库备份完成！')
30 
31 db1 = BakDb('172.19.23.191','root','123456')
32 db1.bak_db()

 

posted on 2018-03-09 11:13  louis_w  阅读(294)  评论(0)    收藏  举报

导航