mysql全备脚本（python3）

import zipfile
import os
import time

db_user = ''
db_passwd = ''
db_host = ''
db_port = '3306'
db_name = ['mysql']
root_path = '/root/'

def _mysql(user,passwd,host,port,db,file_name):
    cmd = 'mysqldump -u{0} -p{1} -h {2} -P {3} {4} >> {5}'.format(user,passwd,host,port,db,file_name)
    return cmd

def db_zip(inpath,outpath):
    db_file = zipfile.ZipFile(outpath,'w',zipfile.ZIP_DEFLATED)
    db_file.write(inpath)
    db_file.close()

def backup():
    date_time = time.strftime("_%Y-%m-%d", time.localtime())
    for i in db_name:
      file_name = root_path + i + '/' + i
      zip_name = file_name + date_time + '.zip'
      if not os.path.isdir(root_path+i):
         os.makedirs(root_path+i)
      print ('开始备份{0}数据库'.format(i))
      mysqldump_cmd = _mysql(db_user,db_passwd,db_host,db_port,i,file_name)
      os.system(mysqldump_cmd)
      db_zip(file_name,zip_name)
      if os.path.isfile(zip_name):
         print ('{0}数据库备份成功,保存路径为:{1}'.format(i,zip_name))
      os.remove(file_name)
      
backup()