RE: LOAD DATA LOCAL INFILE issue

2004-08-10 Thread Logan, David (SST - Adelaide)
8408 4259 - Fax -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 August 2004 3:19 PM To: Logan, David (SST - Adelaide) Cc: MySQL List Subject: Re: LOAD DATA LOCAL INFILE issue Well, as you say, that error message means it's been disabled in either

LOAD DATA LOCAL INFILE issue

2004-08-09 Thread Logan, David (SST - Adelaide)
Hi Folks, I am having a few issues with a LOAD DATA LOCAL INFILE command. As you can see by the command below, I am receiving an error 1148. The documentation states this is generally because I don't have --enable-local-infile on in both client and server. I have switched it on via command line

Re: LOAD DATA LOCAL INFILE issue

2004-08-09 Thread Michael Stassen
Perhaps the problem is that there is no such option as --enable-local-infile in the mysql client. I believe you want --local-infile. Client options are detailed in the manual http://dev.mysql.com/doc/mysql/en/mysql.html. Michael Logan, David (SST - Adelaide) wrote: Hi Folks, I am having a few

RE: LOAD DATA LOCAL INFILE issue

2004-08-09 Thread Logan, David (SST - Adelaide)
- Adelaide) Cc: MySQL List Subject: Re: LOAD DATA LOCAL INFILE issue Perhaps the problem is that there is no such option as --enable-local-infile in the mysql client. I believe you want --local-infile. Client options are detailed in the manual http://dev.mysql.com/doc/mysql/en/mysql.html. Michael

Re: LOAD DATA LOCAL INFILE issue

2004-08-09 Thread Michael Stassen
Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 August 2004 2:37 PM To: Logan, David (SST - Adelaide) Cc: MySQL List Subject: Re: LOAD DATA LOCAL