An easy way to upload massive data into a mysql database is using mysqlimport.
Assume that you have a text tab delimited file named import.csv with three columns field1, field2 and field3.

Then you can run mysqlimport utility and import this text file to a database table named import

mysqlimport -u<username> p<password> –local <databasename> import.csv

By admin