I'm not doing that. I'm doing C:>mysql -r -N fall02 < \mysqluw\mysql.txt
(i.e. using the "mysql" command from DOS, and running a batch file) And I didn't change any configuration defaults since installing mySQL on this machine. ----- Original Message ----- From: "Sqlcoders.com Programming Dept" <[EMAIL PROTECTED]> To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; "Mysql" <[EMAIL PROTECTED]> Sent: Monday, September 09, 2002 8:31 AM Subject: RE: LOAD DATA LOCAL INFILE "not allowed this version"? One can disable all LOAD DATA LOCAL commands in the MySQL server by starting mysqld with --local-infile=0. In the case that LOAD DATA LOCAL INFILE is disabled in the server or the client, you will get the error message (1148): The used command is not allowed with this MySQL version http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html > -----Original Message----- > From: Uriel Wittenberg [mailto:[EMAIL PROTECTED]] > Sent: 08 September 2002 16:24 > To: [EMAIL PROTECTED] > Subject: LOAD DATA LOCAL INFILE "not allowed this version"? > > > The command > > LOAD DATA LOCAL INFILE "C:\\MO10.txt" > INTO TABLE stud1 > fields terminated by "/" > lines terminated by '\r\n'; > > produces: > > ERROR 1148 at line 1: The used command is not allowed with this MySQL vers > > Could someone explain why?? > > I'm running version "MYSQL Ver 11.18 Distrib 3.23.51, for Win95/Win98 > (i32)" under WinXP Home standalone (i.e., no network, just one machine). > > I used to do this routinely under Win Me. > > Thanks in advance, > > Uriel > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
