in reply to Re: LOAD DATA LOCAL INFILE not working
in thread LOAD DATA LOCAL INFILE not working

Yes, all the files are on the same unix server. For the database I do not have admin rights but have all other privileges. My file permission is -rw-r--r-- temp.txt

user@localhost:~$ perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[call +er(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do' Monkey say Monkey do

Replies are listed 'Best First'.
Re^3: LOAD DATA LOCAL INFILE not working
by Anonymous Monk on Nov 15, 2012 at 18:01 UTC

    Hi, Its working now. I was opening temp.txt to write data and then load the contents into the database. LOAD DATA LOCAL INFILE failed to upload because I did not CLOSE temp.txt before uploading into the database. Thanks for the help!