List:General Discussion« Previous MessageNext Message »
From:mos Date:October 9 2005 12:28am
Subject:Re: how do I see warnings from bulk loads?
View as plain text  
At 12:50 PM 10/8/2005, you wrote:
>Paul DuBois wrote:
>>At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
>>
>>>Hi All,
>>>
>>>I'm bulkloading my instance and I'm getting a return message at the end 
>>>of the load like this:
>>>
>>>mysql> \. vm_load.txt
>>>Query OK, 164 rows affected, 113 warnings (0.01 sec)
>>>Records: 164  Duplicates: 0  Warnings: 113
>>>
>>>When I load the data line by line, I get no warnings.
>>>
>>>How can I see what is going wrong?
>>
>>SHOW WARNINGS
>>immediately after your LOAD DATA statement.
>>Requires 4.1 or higher.
>>http://dev.mysql.com/doc/mysql/en/show-warnings.html
>
>Thanks  that got me where I need to be
>
>All hail St Paul!!!

I didn't know he was from Minnesota!?<lol>

Mike


Thread
how do I see warnings from bulk loads?Bruce Ferrell8 Oct
  • Re: how do I see warnings from bulk loads?Paul DuBois8 Oct
    • Re: how do I see warnings from bulk loads?Bruce Ferrell8 Oct
      • Re: how do I see warnings from bulk loads?mos9 Oct