List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 14 2002 1:10pm
Subject:Re: load data infile and warnings
View as plain text  
At 12:52 +0200 6/14/02, Harald Fuchs wrote:
>In article <p0511176fb92e694753f3@[192.168.0.33]>,
>Paul DuBois <paul@stripped> writes:
>
>>>  I imported a text file and got following results:
>>>
>mysql> load data local infile 'update.txt' into table PLZV lines
>>>  terminated by '\r\n' ignore 2 lines;
>
>>>  Query OK, 46658 rows affected (0.66 sec)
>>>  Records: 46658  Deleted: 0  Skipped: 0  Warnings: 4
>>>
>>>  Where are the warnings stored? Can I find out what went wrong during
>>>  the import?
>
>
>>  If you have DBI installed so that you can run MySQL Perl scripts:
>
>>  http://www.kitebird.com/mysql-cookbook/
>
>>  Look for the load_diag.pl note.
>
>Thanks for the interesting hint.  However, there's something I don't
>quite understand:  load_diag.pl creates a temporary table named by
>default "_load_diag_<process_id>".  Why don't you use a "CREATE
>TEMPORARY TABLE load_diag" instead?  You would not have to mess with
>process IDs or "DROP TABLE IF EXISTS".

For MySQL < 3.23.

>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread111968@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
load data infile and warningsOliver Vecernik13 Jun
  • Re: load data infile and warningsPaul DuBois13 Jun
  • Re: load data infile and warningsHarald Fuchs14 Jun
    • Re: load data infile and warningsPaul DuBois14 Jun
  • Re: load data infile and warningsVictoria Reznichenko14 Jun