[Techtalk] mysqlimport importing problems
Charlotte Oliver
COliver at casedesign.com
Fri Nov 22 12:35:34 EST 2002
> > Does anyone know how I could view those Warnings and get a
> heads up on
> > what's going on?
> That's one of the Great Mysteries of the Universe. :))
> According to the online documentation at www.mysql.com, " The
> warnings are not stored anywhere; the number of warnings can
> only be used as an indication if everything went well. " You
> can't read those Warnings, and I get them all the time even
> on operations that worked perfectly fine.
Bad MySQL, bad!
Yeah, I found that article yesterday and shook my head. It's not a
helpful attribute at all! :)
> Try leaving out the --columns=AssetCatID,AssetCategory since
> you only have those two columns anyway, and adding
> --fields-terminated-by="," and see if that works.
> Like Linda, I prefer LOAD DATA LOCAL to mysqlimport, so I
> went to that page (http://www.mysql.com/doc/en/LOAD_DATA.html) and
found
> this: "LOAD DATA INFILE also generates warnings when there are too
few or
> too many fields in the input row" which makes me think you have some
> extraneous characters in your input file maybe?
*nod* I got so frustrated that I tried importing another file and had
it work instantaneously.
Go figure, right?
I'm guessing that I had extraneous characters in the file and that's
what was making it goof, so this morning, I reexported it just as a tab
delineated file and it imported correctly.
Yay!
Thanks again to the 'chix for all your help!
Charlotte
More information about the Techtalk
mailing list