how to print warnings from mysqlimport...debug_options ??
am 27.05.2005 23:02:21 von 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
Re: how to print warnings from mysqlimport...debug_options ??
am 28.05.2005 08:41:22 von 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 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
Re: how to print warnings from mysqlimport...debug_options ??
am 21.06.2005 15:47:43 von 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