如果您想将本地数据库转移到在线数据库,则需要进行以下步骤:
import mysql.connector
import csv
# Connect to the local database
cnx = mysql.connector.connect(user='username', password='password', host='127.0.0.1', database='database_name', port='3306')
# Get all tables from the database
cursor = cnx.cursor()
query = "SHOW TABLES"
cursor.execute(query)
# Export data from each table to a CSV file
for table_name in cursor.fetchall():
query = "SELECT * FROM {}".format(table_name[0])
cursor.execute(query)
results = cursor.fetchall()
csv_file = open(table_name[0] + ".csv", 'w')
writer = csv.writer(csv_file)
writer.writerow([i[0] for i in cursor.description])
for row in results:
writer.writerow(row)
csv_file.close()
cursor.close()
cnx.close()
import pymysql
import boto3
# Connect to the online database
cnx = pymysql.connect(host='database_host', user='username', password='password', database='database_name')
# Import data from the CSV file into MySQL database
s3 = boto3.client('s3')
s3.download_file('bucket_name', 'file_name.csv', 'file_name.csv')
cursor = cnx.cursor()
query = """
LOAD DATA LOCAL INFILE 'file_name.csv'
INTO TABLE table_name
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 ROWS
"""
cursor.execute(query)
cnx.commit()
cursor.close()
cnx.close()
上一篇:本地数据库中通过关键字搜索功能
下一篇:本地数据上传到ubuntu