mysql数据库表数据全量同步

mysqldump -u username -p password database_name table_name > backup.sql

mysql -u username -p password database_name < backup.sql

SELECT * INTO OUTFILE '/path/to/backup.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name;

LOAD DATA INFILE '/path/to/backup.csv'
INTO TABLE table_name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

import pymysql

# 连接源数据库
source_conn = pymysql.connect(host='source_host', user='username', password='password', db='database_name')
source_cursor = source_conn.cursor()

# 连接目标数据库
target_conn = pymysql.connect(host='target_host', user='username', password='password', db='database_name')
target_cursor = target_conn.cursor()

# 查询源表数据
source_cursor.execute("SELECT * FROM table_name")
data = source_cursor.fetchall()

# 插入数据到目标表
for row in data:
    target_cursor.execute("INSERT INTO table_name VALUES (%s, %s, %s)", row)

# 提交事务
target_conn.commit()

# 关闭连接
source_cursor.close()
source_conn.close()
target_cursor.close()
target_conn.close()