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
