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