Re: Load Data Local Infile not Working

[Barry Galbraith]

On further investigation, I've found more errors.
Your table has no PRIMARY KEY specified.
Some rows are missing data for some fields.
The copy I took of your data had no tabs '\t' when I copy\paste into my text editor.
When I fixed that (which may not be your fault!) the data does load, but with errors for missing fields.
You'll need to fix your column count, and your PRIMARY INDEX.

Good luck,
Barry.