Hi!
Wednesday, May 08, 2002, 10:22:39 PM, you wrote:
CR> Well, I thought it was working, and the conversion does in fact work.
CR> But when I try to create a new database, it doesn't like the
CR> "local-infile=1" and gives me an error. If I get rid of that my.cnf
CR> file that I put there, I can create databases fine but I can't do the
CR> data conversion from text to MySQL.
Yeah, I know about this. All client-side programs like mysqldump,
mysqladmin are looking into [client] section of my.cnf(my.ini) and
they know nothing about local-infile option..
Possible solutions:
1. Use CREATE DATABASE statement instead of mysqladmin create
<database_name>, SELECT INTO OUTFILE for writing data into the text
file.
2. Comment out "local-infile" in the [client] section before using
another client program.
3. Upgrade MySQL server to 4.0.1, there are no need to specify
local-infile=1 in my.cnf there.
CR> Argh. :) Any ideas?
CR> Thanks!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
