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.)


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 surveying the Monastery: (4)
As of 2015-07-30 01:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (269 votes), past polls