Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries



Links

Issociate
Impressum

#1: how to print warnings from mysqlimport...debug_options ??

Posted on 2005-05-27 23:02:21 by Bomb Diggy

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/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Report this message

Mr Ad

Google

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

Posted on 2005-05-28 08:41:22 by 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 <techguy_chicago@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.

>

>

>

>

> __________________________________

> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ 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/mysql?unsub=gcdmg-mysql@m.gmane.org

Report this message

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

Posted on 2005-06-21 15:47:43 by 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/mysql?unsub=gcdmg-mysql@m.gmane.org

Report this message