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
CR
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?
: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
-
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 files
--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.com Inc.
St. John's, Newfoundland
Tel: 709.737.4485