By default, "LOAD DATA INFILE ..." is disabled (I am not sure from which
version). You may need to compile MySQL with -enable-local-infile". You
may find details on www.mysql.com .
Ruth
- Original Message -
From: "mysql" <[EMAIL PROTECTED]>
To: "mySQL List" <[EMAIL PROTECTED]>
Sent: Tue
I ran into this too. I assume it is a limitation on the free version of MySQL, and
that
you have to pay to use "load data" in an SQL script. To import my data files, I use
the "mysqlimport" function from the command line or batch file. It seems to support
most of the "load data" options.
-
