Always use Load Data Infile as a first attempt for huge sets of data.
Mysql Manual page on Load Data Infile.
Wrote up several answers for this question, but for a peer comparison, see this guy’s question and my Answer and his time comparisons of Workbench vs Load Data Infile.