将数据库传至腾讯云服务器

import pymysql
from tencentcloud.common import credential
from tencentcloud.common.profile.client_profile import ClientProfile
from tencentcloud.common.profile.http_profile import HttpProfile
from tencentcloud.cdb.v20170320 import cdb_client, models

# 初始化凭证信息
cred = credential.Credential("your_secret_id", "your_secret_key")
httpProfile = HttpProfile()
httpProfile.endpoint = "cdb.tencentcloudapi.com"

clientProfile = ClientProfile()
clientProfile.httpProfile = httpProfile
client = cdb_client.CdbClient(cred, "ap-guangzhou", clientProfile)

# 创建数据库实例
req = models.CreateDBInstanceRequest()
params = {
    "InstanceName": "test-instance",
    "InstanceType": 1,
    "Engine": "mysql",
    "Memory": 1,
    "Volume": 20
}
req.from_json_string(params)
resp = client.CreateDBInstance(req)
print(resp.to_json_string(indent=2))

# 迁移数据
source_conn = pymysql.connect(host="source_host", user="source_user", password="source_password", db="source_db")
target_conn = pymysql.connect(host="target_host", user="target_user", password="target_password", db="target_db")

with source_conn.cursor() as source_cursor, target_conn.cursor() as target_cursor:
    source_cursor.execute("SELECT * FROM source_table")
    result = source_cursor.fetchall()
    for row in result:
        target_cursor.execute("INSERT INTO target_table VALUES (%s, %s, %s)", row)
target_conn.commit()

source_conn.close()
target_conn.close()