On Tue, Mar 25, 2003 at 11:05:06PM -0800, Jeff Kilbride wrote:
Replication doesn't seem to be replicating LOAD DATA INFILE correctly in
3.23.56. Starting with a master and slave that were in sync, I imported a
file:
[snip]
Notice that the slave doesn't skip the records that the master does,
Jeremy,
Also, is there any way to find out what records were skipped and
why?
Nope. Not yet. I think that's coming in 4.1?
Yes and no: http://www.mysql.com/doc/en/SHOW_WARNINGS.html
The MySQL server sends back the total number of warnings and errors
you got for the last command.
My
Replication doesn't seem to be replicating LOAD DATA INFILE correctly in
3.23.56. Starting with a master and slave that were in sync, I imported a
file:
---
MASTER
mysql select count(*) from list where sourceID=0;
+--+
| count(*) |
+--+
|0 |