I'm following this thread with interest, because I'm running into the same
problem: When I tried the load data local command, I got the same error
Christy got: "ERROR 1148: the used command is not allowed in this mysql
version." And I'm using version 3.23.49 (the book I have says that load
data local won't work if one is using something earlier than 3.22.15)
I, too, don't see a my.cnf file on my computer...I also don't see a /etc
directory.
I know that this isn't very helpful, but at least it shows that Christy is
not alone with this problem!
Thanks in advance for your help.
best,
Matt
----- Original Message -----
From: Christy Roberts <christy@stripped>
To: 'Gurhan Ozen' <c-gurhan.ozen@stripped>; <mysql@stripped>
Sent: Tuesday, May 07, 2002 1:38 PM
Subject: RE: RE: Converting text files to MySQL
> When I do a search on my entire machine, the only 4 cnf files it finds
> are those four samples. Where should the file be? I installed and
> started MySQL myself but I did it under an administrator account. I'm
> now running under my own account...would this make a difference?
>
> -----Original Message-----
> From: Gurhan Ozen [mailto:c-gurhan.ozen@stripped]
> Sent: Tuesday, May 07, 2002 2:56 PM
> To: Christy Roberts; mysql@stripped
> 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 are given, mysqld will read
> options from /etc/my.cnf .
>
> Gurhan
>
>
> -----Original Message-----
> From: Christy Roberts [mailto:christy@stripped]
> Sent: Tuesday, May 07, 2002 1:00 PM
> To: 'Gurhan Ozen'; mysql@stripped
> 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-----
> From: Gurhan Ozen [mailto:c-gurhan.ozen@stripped]
> Sent: Tuesday, May 07, 2002 12:58 PM
> To: Christy Roberts; mysql@stripped
> 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 with MySQL downloads to be used
> as
> an example...
>
> See: http://www.mysql.com/doc/O/p/Option_files.html
>
> Gurhan
>
> -----Original Message-----
> From: Christy Roberts [mailto:christy@stripped]
> Sent: Tuesday, May 07, 2002 11:02 AM
> To: 'Egor Egorov'; mysql@stripped
> Subject: RE: RE: Converting text files to MySQL
>
>
> 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? Thanks so much for your help!
>
>
> Egor Egorov wrote:
>
> Add in your my.cnf file rows:
> [mysqld]
> local-infile=1
>
> [client]
> local-infile=1
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread108251@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-mgold1=gc.cuny.edu@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
