获取服务器端数据到云数据库

import mysql.connector
from mysql.connector import Error

def create_server_to_cloud_connection():
    try:
        connection = mysql.connector.connect(
            host='your_cloud_mysql_host',
            database='your_database',
            user='your_username',
            password='your_password'
        )
        if connection.is_connected():
            print("Successfully connected to the cloud MySQL database")
            return connection
    except Error as e:
        print(f"Error while connecting to MySQL: {e}")
        return None

def insert_data(connection, data):
    cursor = connection.cursor()
    query = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)"
    cursor.execute(query, data)
    connection.commit()
    print("Data inserted successfully")

# 示例数据
data_to_insert = ('value1', 'value2')

# 获取连接并插入数据
connection = create_server_to_cloud_connection()
if connection:
    insert_data(connection, data_to_insert)
    connection.close()