Right now, you pretty much have to compare the input to your loaded
table and see which records are missing. Check the input file to see
what is wrong with them.
Dominic Brander wrote:
> Hi
>
> I'm trying to load data from a tab deliminated textfile into my table
> named blick_test:
> load data local infile "public_html/DB2.txt" into table blick_test
> ignore 1 lines;
>
> this works pretty fine, except I only get the first 256 records instead
> of all 503!
> message:
> Query OK, 256 rows affected (0.01 sec)
> Records: 503 Deleted: 0 Skipped: 247 Warnings: 741
>
> how can I turn on the warnings?
> is there any limit in importing records from a textfile?
>
> thanks
>
> dominic
>
> ________________________________________________________________________
> dominic brander - snowflake productions gmbh - http://www.snowflake.ch
> 01 772 80 21
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
