* [EMAIL PROTECTED]
> Hie
>           I'm new in MySQL.....anyone out there can help please?
> I'm actually experimenting with the mysqlimport utility to import
> data from
> a text file.........however i'm always getting this error upon the command
>
> c:\mysql\bin>mysqlimport - - local - -fields-terminated-by="," test
> newtest.txt
>
> ERROR: The used command is not allowed with this MySQL version, when using
> table: newtest
>
> P.S. My SQL version is Ver. 11.16 Distrib 3.23.49 for Win95/98 (i32)
>          Also i created a txt file with the following structure
>          100,200
>          200,200
>          300,300
>          .............
>          My table is newtest with 2 fields of char datatype of size 10.

>From the manual:

"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."

(There is probably a typo here... I guess LOCAL will only work if you HAVE
enabled your client to support LOCAL... AND you have not started the server
with --local-infile=0...)

<URL: http://www.mysql.com/doc/L/O/LOAD_DATA.html >
<URL: http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html >

Beware that there was done some changes to LOAD DATA LOCAL in version
3.23.49, and some bugs was intrudused (--enable-local-infile
(and --local-infile) did not work, IIRC). These bugs was fixed in version
3.23.50.

<URL: http://www.mysql.com/doc/N/e/News-3.23.49.html >
<URL: http://www.mysql.com/doc/N/e/News-3.23.50.html >

--
Roger


---------------------------------------------------------------------
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

Reply via email to