Re: how to print warnings from mysqlimport...debug_options ?? - Gleb Paharenko - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlRe: how to print warnings from mysqli...

From	Sent On	Attachments
Bomb Diggy	27 May 2005 14:01
Gleb Paharenko	27 May 2005 23:41

Subject:	Re: how to print warnings from mysqlimport...debug_options ??
From:	Gleb Paharenko (gleb...@ensita.net)
Date:	05/27/2005 11:41:00 PM
List:	com.mysql.lists.mysql

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 <tech...@yahoo.com> 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.