I got it....i wasn't able to add the local-infile option in my server
config....thanks for the help....
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No. (Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)
-----Original Message-----
From: Jan Peuker [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject: Re: LOAD DATA in LOCAL
Hi,
* I am not a professional, but I think there is no error in your
config.
The statement runs on my .49.
Change in .50 was
- Fixed binary builds to use --enable-local-infile. (this affects nt
versions, which means your dll!)
Nothing on .51.
* I think you get the message: "The used command is not allowed with
this
MySQL version" like in 4.2.4. Security Issues Bulletin? Maybe you
have to
connect to your server using "mysql --local-infile". I guess...
* Do you use just "load data infil 'some.txt' into mytable;" or are
there
any other commands?
please refer to: http://www.mysql.com/doc/T/O/TODO_future.html
* Have you tried mysqlimport already?
just my 0,01 ;)
jan
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 9:41 AM
Subject: RE: LOAD DATA in LOCAL
> Is there any problem in my.cnf file?
>
> [mysqld]
> log-bin
> server-id=165
> skip-bdb
> skip-name-resolve
> skip-innodb
> flush
> port=3306
> socket=/tmp/mysql.sock
> set-variable = key_buffer_size=16M
> set-variable = max_allowed_packet=1M
> set-variable = flush_time=300
>
> I only use MyISAM...LOAD DATA INFILE syntax I used in MySQL ver
3.23.44 in
> working fine...and my first suspect about this is the
LIBMYSQL.DLL, maybe
> they added some feature to MySQL ver 3.23.51 which affect the LOAD
> syntax...I got an error when I execute the command...it says that
its not
> supported...
>
>
>
>
> R.B.Roa
> Traffic Management Engineer
> PhilCom Corporation
> Tel. No. (Office) (088) 858-1028
> (Home) (088) 858-8889
> Mobile No. (63) (919-3085267)
>
>
>
>
> -----Original Message-----
> From: Jan Peuker [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 16, 2002 3:15 PM
> To: [EMAIL PROTECTED]
> Subject: Re: LOAD DATA in LOCAL
>
> Hi ,
>
> check this: "In MySQL 3.23.49 and MySQL 4.0.2 LOCAL will only work
> if you
> have not started mysqld with --local-infile=0 or if you have not
> enabled
> your client to support LOCAL. See section 4.2.4 Security issues
with
> LOAD
> DATA LOCAL. "
>
> maybe that's what you are looking for.
> see: http://www.mysql.com/doc/L/O/LOAD_DATA.html
> and: http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html
>
> just my 0,02
>
> jan
>
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 16, 2002 8:55 AM
> Subject: LOAD DATA in LOCAL
>
>
> > Hi,
> >
> > Im just wondering why MySQL ver 3.23.51 is not supporting LOAD
> DATA INFILE
> > syntax, I downgrade my server to the older one which is MySQL
ver
> 3.23.44,
> > is there any bug about using it in the latest version?
> >
> >
> >
> > R.B.Roa
> > Traffic Management Engineer
> > PhilCom Corporation
> > Tel. No. (Office) (088) 858-1028
> > (Home) (088) 858-8889
> > Mobile No. (63) (919-3085267)
> >
> >
> >
> >
> >
>
---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail
> <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> >
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
