List:General Discussion« Previous MessageNext Message »
From:Christy Roberts Date:May 7 2002 5:00pm
Subject:RE: RE: Converting text files to MySQL
View as plain text  
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



Thread
Converting text files to MySQLChristy Roberts6 May
  • Re: Converting text files to MySQLEgor Egorov7 May
    • RE: Converting text files to MySQLChristy Roberts7 May
      • Re: RE: Converting text files to MySQLEgor Egorov7 May
        • RE: RE: Converting text files to MySQLChristy Roberts7 May
          • RE: RE: Converting text files to MySQLGurhan Ozen7 May
            • RE: RE: Converting text files to MySQLChristy Roberts7 May
              • RE: RE: Converting text files to MySQLGurhan Ozen7 May
                • RE: RE: Converting text files to MySQLChristy Roberts7 May
                  • Re: RE: Converting text files to MySQLMatthew K. Gold7 May
          • Re: RE: RE: Converting text files to MySQLEgor Egorov8 May
            • RE: RE: RE: Converting text files to MySQLChristy Roberts8 May
              • Re: RE: RE: RE: Converting text files to MySQLEgor Egorov8 May
                • RE: RE: RE: RE: Converting text files to MySQLChristy Roberts8 May
                • RE: RE: RE: RE: Converting text files to MySQLChristy Roberts8 May
                  • Re: RE: RE: RE: RE: Converting text files to MySQLEgor Egorov9 May
Re: Converting text files to MySQLTerrence Cox7 May