create an automated system that backs up and restores data stored in a MySQL database

import mysql.connector
from mysql.connector import Error
import os
from subprocess import Popen, PIPE


def backup():
    try:
        connection = mysql.connector.connect(host='127.0.0.1',
                                             database='my_database',
                                             user='root',
                                             password='password')
        if connection.is_connected():
            db_Info = connection.get_server_info()
            print("Connected to MySQL Server version ", db_Info)
            cursor = connection.cursor()
            cursor.execute("select database();")
            record = cursor.fetchone()
            print("Your connected to database: ", record)
            pipe = Popen(['/usr/bin/mysqldump', '-u', 'root', '--databases', 'my_database', '--password=password'], stdout=PIPE)
            output = pipe.communicate()[0]
            print(output)
            with open('/home/database_backup.sql', 'wb') as f