Re: how to print warnings from mysqlimport...debug_options ??

2005-06-21 Thread Trevor Nichols 
Hi Guys,

I have been searching for the answer to this question for a while.  The
answer is so obvious, yet there was no useful source of documentation
that showed it.  I am using the load data infile syntax rather than the
command line utility.  To get the warnings the show warnings command
is sufficient.

mysql load data  infile '/sttn/done/st062020' replace into table
mm_stock;
Query OK, 2739 rows affected, 21 warnings (0.20 sec)
Records: 2739  Deleted: 0  Skipped: 0  Warnings: 21

mysql show warnings;

-Trev


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to print warnings from mysqlimport...debug_options ??

2005-05-28 Thread Gleb Paharenko 
Hello.



Are you sure that you have compiled in debugging

support? You have an old version of MySQL, and there

was a bug when MySQL programs were showing that they have

debugging, but really they were without it.



  



Bomb Diggy [EMAIL PROTECTED] wrote:

 I can't seem to get ahold of the 6 warnings being

 generated when I import a csv file.  

 

 My ~/.my.cnf file says this:

 

 [client]

 fields-terminated-by=,

 fields-enclosed-by=\

 #debug=log.txt

 #debug=d,info,error,query,general,where:1,load.trace

 debug=warning,load.trace

 

 Nothing I do in the 'debug' param seems to actually

 output any information.

 

 Here's my command:

 

 mysqlimport -v -h [host] [database]

 [table_and_file_name].csv -u [username] -p

 

 Here's my version info:

 

 mysqlimport  Ver 3.4 Distrib 4.0.18, for pc-linux

 (i686)

 

 Here's my output to STDOUT/STDERR:

 

 Connecting to [hostname]

 Selecting database [database]

 Loading data from LOCAL file: [table_and_file_name.csv

 into [table_name]

 [database].[table_name]: Records: 3  Deleted: 0 

 Skipped: 0  Warnings: 6

 Disconnecting from [hostname]

 

 I want to see those 6 warnings.  I've tried

 command-line '--debug=foo' as well.

 

 Thanks.

 

 

 



 __ 

 Do you Yahoo!? 

 Yahoo! Small Business - Try our new Resources site

 http://smallbusiness.yahoo.com/resources/

 



-- 
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]