re: Re: LOAD DATA LOCAL INFILE not allowed this version?

2002-09-10 Thread Victoria Reznichenko
Uriel, Monday, September 09, 2002, 4:21:40 AM, you wrote: C:mysql -r -N fall02 \mysqluw\mysql.txt UW (i.e. using the mysql command from DOS, and running a batch file) UW And I didn't change any configuration defaults since installing mySQL on UW this machine. Put local-infile=1 in the

Re: Re: LOAD DATA LOCAL INFILE not allowed this version?

2002-09-10 Thread Uriel Wittenberg
THANKS VERY MUCH! That worked! - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 9:15 PM Subject: re: Re: LOAD DATA LOCAL INFILE not allowed this version? [.] Put local-infile=1 in the [mysqld] and [mysql

LOAD DATA LOCAL INFILE not allowed this version?

2002-09-08 Thread Uriel Wittenberg
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

RE: LOAD DATA LOCAL INFILE not allowed this version?

2002-09-08 Thread Sqlcoders.com Programming Dept
://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

Re: LOAD DATA LOCAL INFILE not allowed this version?

2002-09-08 Thread Uriel Wittenberg
[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