Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^2: LOAD DATA LOCAL INFILE not working

by Anonymous Monk
on Nov 15, 2012 at 14:05 UTC ( #1004016=note: print w/replies, xml ) Need Help??


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!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1004016]
help
Chatterbox?
[marto]: hey Corion, good weekend?
[prospect]: Thank you
[marto]: no problem prospect
[Corion]: I hope you all spent a good weekend!
[Discipulus]: good morning eumonks!
[Discipulus]: yes thanks, mostly at seaside, but the waterpolo tournemts went bad, very bad.. ;=(
[marto]: hey Discipulus, Corion a reasonable weekend. The boys first trip to the cinema
[Corion]: Discipulus: You got pushed too much under water?
[Corion]: marto: Oooh - cinema... I guess that's something I could do with my godson and sibling and sister as well, but I guess that getting a six year old and two four year olds into one movie is a tough sell ;)
[marto]: busy weekend, no me time :P

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (7)
As of 2017-07-24 08:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I came, I saw, I ...
























    Results (348 votes). Check out past polls.