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
PM
To: 'Gurhan Ozen'; [EMAIL PROTECTED]
Subject: RE: RE: Converting text files to MySQL
Thanks, Gurhan. I don't seem to have a my.cnf - the only cnf files I
have are the four samples - so can I just use one of the sample ones,
change the name, and add the local-infile =1 line?
-
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
/Option_files.html
Gurhan
-Original Message-
From: Christy Roberts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 11:02 AM
To: 'Egor Egorov'; [EMAIL PROTECTED]
Subject: RE: RE: Converting text files to MySQL
Thanks, Egor. I still can't get it to work though. I added those
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?
Christy,
Tuesday, May 07, 2002, 3:07:25 PM, you wrote:
CR>> I've been trying to import text files into MySQL, but I can't get it
CR> 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
CR> command
CR>> but I
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
Christy,
Monday, May 06, 2002, 8:56:53 PM, you wrote:
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
I've been trying to import text files into MySQL, but I can't get it to
work. I'm new to MySQL and am still getting familiar with it, so
perhaps I'm missing something. I'm using the LOAD DATA LOCAL command
but I keep getting error 1148 "The used command is not allowed with this
MySQL version."
