Data: 1 db, 2000 tables, 2000 table data, 30 column records per table, 4.3w records per table, a total of 86388,670 records.

Machine: linux 64bit 8G memory 4 core [email protected]

Basic idea:

mysql -utest -pxxxx -s -e "source xxxx.sql"

Put the load statement in xxxx.sql

load grammar:

load data  [low_priority] [local] infile 'file_name.txt' [replace | ignore]

If the serial import of data will be slow, consider parallel, but there may be conflicts, resolution:

Empty the table before load

truncate table xxxx  or  delete from table xxxx;

Or use the replace or ignore keywords.