doesn't seem to
work. I tried using the command --enable-local-infile but apparently
that's only compatible with version 3.23.48 and before, and we have
3.23.49. Is there something else I should do? Can anyone help me
please? Thanks so much!
Christy Roberts
Technical Project Lead
iMIRADOR.c
CR> I've been trying to import text files into MySQL, but I can't get it
to
CR> work. I'm new to MySQL and am still getting familiar with it, so
CR> perhaps I'm missing something. I'm using the LOAD DATA LOCAL
command
CR> but I keep getting error 1148 "The used command is not allowed with
this
Thanks, Egor. I still can't get it to work though. I added those lines
under the [mysqld] and [client] sections - into my four .cnf files, they
are my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf. I
dind't have a my.cnf like you mentioned. Is there something else I
should be doing?
02 12:58 PM
To: Christy Roberts; [EMAIL PROTECTED]
Subject: RE: RE: Converting text files to MySQL
Christy,
You need to edit the defaults file for your MySQL server. It is by
default,
/etc/my.cnf , unless another one is specified when mysqld is started.
The
four files that you have mentioned comes
ssage-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 2:56 PM
To: Christy Roberts; [EMAIL PROTECTED]
Subject: RE: RE: Converting text files to MySQL
are you sure you don't have a my.cnf file in /etc dir? Who has
installed,
started MySQL server? If no default