a python program based on creating an automated system that backs up and restores data stored in a MySQL database

import os

def backup_mysql_db(db_name, db_user, db_pass, db_host="localhost", db_port=3306):
  """
  Function that perform a backup of the database to the OS temporary 
  directory (/tmp).
  """
  db_name = db_name
  db_user = db_user
  db_pass = db_pass
  db_host = db_host
  db_port = db_port

  # create the backup file and set the file name
  bkp_file = db_name + '_backup.sql'

  # create the command that will be used to create the backup
  bkp_cmd = 'mysqldump -u ' + db_user + ' -p' + db_pass + ' -h ' + db_host + ' -P ' + str(db_port) + ' ' + db_name + ' > ' + '/tmp/' + bkp_file

  # perform the backup
  os.system(bkp_cmd)

  return bk