How to enable "load data infile" in MySQL

Here's something you can try:

Add this line: local-infile=1

to your /etc/my.cnf file (in the [mysql] "section"), and then restart via SSH and try again...

awesome! that did it-

Here's what I did:

edit my.cnf in /etc/:

[mysqld]
...(other stuff)
local-infile=1
[mysql]
...(other stuff)
local-infile=1

then shutdown, then start mysql:

shell> mysqladmin shutdown
shell> cd /usr/libexec
shell> mysqld

then I have to close that shell connection and open a new one, then:

shell> mysql