python备份mysql数据库

介绍使用python结合mysqldump对mysql数据库进行备份

import os
import sys
import configparser
import time

def test_file_path(fp):
  if not os.path.exists(fp):
    raise RuntimeError('file {} not found'.format(fp))

def backup_mysqldb(backup_param):
  test_file_path(backup_param['mysql']['dump'])
  test_file_path(backup_param['bak']['cmd_zip'])
  cmd1 = '{dump} -u{user} -p{password} -h{hostip} \
  -P{port} {dbname}'.format(**backup_param['mysql'])
  print(cmd1)
  backup_name = time.strftime('mysqlbackup%Y%m%d_%H%M%S')
  backup_param['bak']['backup_name'] = backup_name
  cmd2 = backup_param['bak']['cmd_bak'].format(**backup_param['bak'])
  print(cmd2)
  cmd = cmd1 + ' | ' + cmd2
  print(cmd)
  os.system(cmd)

def del_old_backup(backup_param):
  backup_