Hello,
I have a question about the execution cycle of LOAD DATA INFILE.
If I issue a large file via LDI LOCAL, I know that the file is copied to
the MySQL server and executed there.
But at what point does the statement finish from the sender's point of view?
1) When the file is successfully copied?
2) When the file is copied and parsed?
3) When the file is completely processed?
I'm guessing 2).
The reason for asking is to determine what errors may be returned and
how I can deal with them.
Is it possible for the file to be partially processed, say, inserting
the first half of the rows? If 2) or 3), I would say no (barring some
serious server error).
Since LOCAL implies IGNORE, is there any way to get the number of
ignored rows? What about replace?
Ultimately I want to know under what conditions I should reissue the
file, and whether or not that could introduce duplicate entries for
tables with non-unique keys.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
