Re: LOAD DATA LOCAL INFILE not working

Are the temp file, the CGI script and the database all on the same computer?

What user is the database running as? What are he permissions on the temp file?

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

Comment on Re: LOAD DATA LOCAL INFILE not working

Replies are listed 'Best First'.
Re^2: LOAD DATA LOCAL INFILE not working by Anonymous Monk on Nov 15, 2012 at 14:05 UTC
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` [download]	[reply] [d/l]
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!	[reply]