Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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.)


Comment on Re: LOAD DATA LOCAL INFILE not working

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1004048]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2014-09-01 15:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (14 votes), past polls