from subprocess import call, check_call

DEST_HOST = 'dest'
DEST_USER = 'root'
DEST_PASS = 'pass'

LOCAL_USER = 'root'
LOCAL_PASS = 'pass'

DATABASES_TO_TRANSFER = [
    'Database'
]

def run_mysql_command(sql):
    command = ["mysql", "-u", DEST_USER, "-p%s" % DEST_PASS, "-h", DEST_HOST, "-e", '%s'%sql]
    call(command)

def transfer_database(name):
    run_mysql_command("create database %s" % name)
    command = "mysqldump --lock-all-tables -u %(user)s -p%(pass)s -h localhost %(db)s | mysql -v --compress -h %(dest_host)s -u %(dest_user)s -p%(dest_pass)s %(db)s"
    params = {
        "user" : LOCAL_USER,
        "pass" : LOCAL_PASS,
        "db" : name,
        "dest_host" : DEST_HOST,
        "dest_user" : DEST_USER,
        "dest_pass" : DEST_PASS
    }

    check_call(command % params, shell=True)

if __name__ == '__main__':
    for db in DATABASES_TO_TRANSFER:
        run_mysql_command("drop database %s" % db)
        transfer_database(db)