mysqlimport

input file:

1. tablename.txt
2. Tab deliminated by default
3. use full path with all the parent path readable by mysql user

$> mysqlimport -u user -p dbname /path/to/input/tablename.txt

Also if there is autoincrement field , use number 0.

Read More