数据库服务器上云

import mysql.connector
from mysql.connector import errorcode

# 连接到本地MySQL数据库
try:
    local_db = mysql.connector.connect(
        host="localhost",
        user="user",
        password="password",
        database="database"
    )
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with your user name or password")
    elif err.errone == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)

# 连接到腾讯云MySQL数据库
try:
    cloud_db = mysql.connector.connect(
        host="cloud-mysql-host",
        user="cloud-user",
        password="cloud-password",
        database="cloud-database"
    )
except mysql.connector.Error as err:
    print(err)

# 迁移数据
cursor_local = local_db.cursor()
cursor_cloud = cloud_db.cursor()

cursor_local.execute("SELECT * FROM table")
rows = cursor_local.fetchall()

for row in rows:
    cursor_cloud.execute("INSERT INTO table VALUES (%s, %s, %s)", row)

cloud_db.commit()

cursor_local.close()
cursor_cloud.close()
local_db.close()
cloud_db.close()