Converting text files to MySQL

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

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

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 Christy Roberts
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

RE: RE: Converting text files to MySQL

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