Re: Converting text files to MySQL

2002-05-07 Thread Egor Egorov
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

RE: Converting text files to MySQL

2002-05-07 Thread Christy Roberts
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

Re: RE: Converting text files to MySQL

2002-05-07 Thread Egor Egorov
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 keep

RE: RE: Converting text files to MySQL

2002-05-07 Thread Christy Roberts
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?

RE: RE: Converting text files to MySQL

2002-05-07 Thread Gurhan Ozen
/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 lines under

RE: RE: Converting text files to MySQL

2002-05-07 Thread Christy Roberts
: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

RE: RE: Converting text files to MySQL

2002-05-07 Thread Gurhan Ozen
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? -Original Message

RE: RE: Converting text files to MySQL

2002-05-07 Thread Christy Roberts
- 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

Converting text files to MySQL

2002-05-06 Thread Christy Roberts
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.