mysql数据量大怎么导出

# 使用mysqldump进行分批导出
for i in {0..9}; do
    mysqldump -u username -p password --single-transaction --quick --max_allowed_packet=1G --default-character-set=utf8 database_name table_name --where="id >= $i*100000 and id < ($i+1)*100000" > export_batch_$i.sql;
done

# 使用GNU Parallel进行并行导出
parallel -j 4 mysqldump -u username -p password --single-transaction --quick --max_allowed_packet=1G --default-character-set=utf8 database_name table_name --where="id >= {} and id < {}" ::: $(seq 0 999999 10000000)

# 安装MyDumper
wget https://github.com/maxbube/mydumper/releases/download/v0.9.5/mydumper-0.9.5-linux-x86_64.tar.gz
tar -xvzf mydumper-0.9.5-linux-x86_64.tar.gz
cd mydumper-0.9.5-linux-x86_64

# 使用MyDumper导出数据
./mydumper -u username -p password -B database_name -o /path/to/export/directory -c -t 4 -r 5000000

# MySQL配置文件（my.cnf或my.ini）
[mysqld]
innodb_buffer_pool_size = 4G
max_allowed_packet = 1G