Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.xxx.con, www.chasecreditcard.com, error 800c5000, Wwwxxxc,memo, inserting images in postgresql, sending diag reset !!, bhavin retain ni style words, Www.ottest3, Php-cgi.exe not found , unable to change directory to null

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

#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