Hello.
I've looked more carefully through the documentation and source code of mysqlimport. As said in comments at: http://dev.mysql.com/doc/mysql/en/mysqlimport.html MySQL doesn't have the ability to display warnings except in SHOW WARNINGS clause. You can use mysql program with -e option to execute the import and display warnings if your MySQL version is above 4.1.0. Something like this: ./bin/mysql --defaults-file=my.cnf -vvT -uroot test -e " lock tables yo write; load data local infile 'yo.txt' into table yo fields terminated by '|' ; unlock tables; show warnings"; "Joseph E. Maxwell" <[EMAIL PROTECTED]> wrote: > A pain replying to digest in digest mode, change mode to normal > >> >> Warning messages, as from a mysqlimport command, where are they to be >> found? >> >> >> Part of the construct from a cron job script file run at the command >> line interface >> >> $ /usr/local/bin/mysqlimport -v -l --fields-terminated-by="|" >> --local fisheries -L -u administr -p******** $CRONBASE/trawler.tmp >> Connecting to localhost >> Selecting database fisheries >> Locking tables for write >> Loading data from LOCAL file: /usr/local/trawler.tmp into trawler >> fisheries.trawler: Records: 1 Deleted: 0 Skipped: 1 Warnings: 5 >> Disconnecting from localhost >> $ >> >> >> But where are the "Warnings" >> >> >> ------------------------------------------------------------------------ >> A reply; >> ======== >> >> Hello. >> Try increasing the verbosity level, for example, with -vv or -vvv. > > > Increased level with -v -v -v (that appears to be the req'd. syntax) > ==> same results, 5 warnings which I can't find and "skipped" operation > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
