Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: LOAD DATA LOCAL INFILE not working

by erix (Vicar)
on Nov 15, 2012 at 17:47 UTC ( #1004048=note: print w/replies, xml ) Need Help??


in reply to LOAD DATA LOCAL INFILE not working

Just a few thoughts:

Keep an eye on the database log. Are there any errors?

Try loading just a handful of rows first to make sure the whole setup works.

Your statement reeks of mysql: does it run your 'query' in a transaction? Perhaps you just need to COMMIT?

Googling show sthat not all mysql server setups allow load data local. Perhaps you're out of luck?

mysql_local_infile

As of MySQL 3.23.49, the LOCAL capability for LOAD DATA may be disabled in the MySQL client library by default. If your DSN contains the option "mysql_local_infile=1", LOAD DATA LOCAL will be enabled. (However, this option is *ineffective* if the server has also been configured to disallow LOCAL.)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1004048]
help
Chatterbox?
[choroba]: and shows a bar with a note "ohne Triangel"
[choroba]: where "ohne" means "will bend" in Czech
[LanX]: one-day-the- triangle-player-of -an-orchestra-gets -very-sick xD
[choroba]: :)

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (6)
As of 2017-03-27 12:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (319 votes). Check out past polls.