# mysqldump -uroot -p123456 -A > nhy123.sql
import os
import datetime
class BakDb(object):
def __init__(self, ip, username, password, port=3306, path='/tmp/db_bak'):
self.ip = ip
self.username = username
self.password = password
self.port = port
self.path = path
self.path_exist()
def path_exist(self):
if not os.path.isdir(self.path): # 不存在的话就创建!
os.mkdir(self.path)
# mysqldump -u%s(username) -p%s(password) -P%s(port) -h%s(host) -A > nhy123.sql
def bak_db(self):
filename = str(datetime.date.today()) + '.sql'
abs_file = os.path.join(self.path, filename)
command = '''
mysqldump -u{username} -p{password} -P{port} -h{ip} -A > {filename}
'''.format(username=self.username,
password=self.password,
port=self.port,
ip=self.ip,
filename=abs_file)
os.system(command)
print('数据库备份完成!')
db1 = BakDb('192.168.3.1', 'root', '123456')
db1.bak_db()
转载于:https://www.cnblogs.com/wangsilei/p/8522537.html