备份数据库

备份数据库命令：

mysqldump -uroot -p123456 -A >wxc123.sql 备份数据库命令

import os,datetime
class BakDb(object):
    def __init__(self,ip,username,passwd,port=3306,path='E:db_bak'):
        self.ip=ip
        self.username=username
        self.passwd=passwd
        self.port=port
        self.path=path
        self.path_exist()
        # self.bak_db()
    def path_exist(self):
        if not os.path.isdir(self.path):#不存在的话就创建
            os.mkdir(self.path)
    def bak_db(self):
        #mysqldump - u%s - p%s -P%s -h%s -A > wxc123.sql
        filename=str(datetime.date.today())+'.sql'
        abs_file=os.path.join(self.path,filename)#变成绝对路径
        command=r'''
        mysqldump -u{username} -p{passwd} -P{port} -h{ip} -A > {filename}
        '''.format(username=self.username,
                   passwd=self.passwd,
                   port=self.port,
                   filename=abs_file,
                   ip=self.ip)
        print(command)
        os.system(command)

        print('done!数据库备份完成！')
db1=BakDb('211.149.218.16','jxz','123456')
db1.bak_db()