Re: BUG: Load data infile replication - 3.23.56

2003-03-26 Thread Jeremy Zawodny
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,

Re[2]: BUG: Load data infile replication - 3.23.56

2003-03-26 Thread Stefan Hinz
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

BUG: Load data infile replication - 3.23.56

2003-03-25 Thread Jeff Kilbride
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 |