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