The LOAD DATA INFILE command is used to rapidly load data from external text files in MySQL. You should read
http://www.mysql.com/documentation/m...html#LOAD_DATA
and
try
mysql> USE db1;
mysql> LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table;
Hope this helps. As long as your text data is formatted sensibly (eg: tab or comma delimited or something similar) it should be no problem.
----------------------------------------------------------------------