Re: LOAD DATA LOCAL INFILE not working


Syntactic Confectionery Delight
	PerlMonks

by tobyink (Prior)

on Nov 15, 2012 at 07:09 UTC ( #1003942=note: print w/ replies, xml )

Need Help??

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
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]

Node Status^?

node history
Node Type: note [id://1003942]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others rifling through the Monastery: (8)

As of 2013-05-21 05:09 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?