in reply to How do I use a statement handle with DBI?

The LOCAL capability for LOAD DATA may be disabled in the MySQL client library by default. When you connect to the database, add the option "mysql_local_infile=1" to your connect string, LOAD DATA LOCAL will be enabled.

(However, this option doesn't work if the server has also been configured to disallow LOCAL.)

Replies are listed 'Best First'.
Re^2: trouble with statement handles
by rookie604 (Initiate) on Sep 19, 2004 at 02:54 UTC
    Dear whoever gave me a reply, Thank you so much for your reply. Can you please tell me exactly how I would add that option? IN fact, I don't even know what connect string is. As the name says, I am rookie. Young
[reply]
      Have a read of DBD::mysql and look for the keyword 'mysql_local_infile' in the document.

[reply]

In Section Seekers of Perl Wisdom