List:General Discussion« Previous MessageNext Message »
From:Christy Roberts Date:May 8 2002 7:22pm
Subject:RE: RE: RE: RE: Converting text files to MySQL
View as plain text  
Well, I thought it was working, and the conversion does in fact work.
But when I try to create a new database, it doesn't like the
"local-infile=1" and gives me an error.  If I get rid of that my.cnf
file that I put there, I can create databases fine but I can't do the
data conversion from text to MySQL.

Argh. :)  Any ideas?
 
Thanks!
 

-----Original Message-----
From: Egor Egorov [mailto:egor.egorov@stripped] 
Sent: Wednesday, May 08, 2002 12:14 PM
To: mysql@stripped
Subject: Re: RE: RE: RE: Converting text files to MySQL

Christy,
Wednesday, May 08, 2002, 2:54:16 PM, you wrote:

CR> Hi Egor.  For some reason, I have neither of those files...I've
searched
CR> my machine for all CNF files and found only the four samples.  I
have
CR> lots of INI files but neither one called anything close to my.ini.
I
CR> think I may have to give up. <sigh>  :-)  Thanks again for all your
CR> help!

Take one of these files (my-*.cnf) rename it to my.cnf and put into
the root dir of drive C: (or rename to my.ini and put into Windows
dir). Then add necessary lines.

my.cnf and my.ini are option files. What other options you can set in
these files you can read in our manual:
      http://www.mysql.com/doc/O/p/Option_files.html



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