Re: Replication Falls Out Of Sync With LOAD DATA

2007-11-29 Thread Michael Stearne
On Nov 28, 2007 11:18 PM, B. Keith Murphy <[EMAIL PROTECTED]> wrote: > The reason I asked about version is that it looks like there is problem > replcating a load data infile command from some versions of 4.x to 5.x > slaves. Master and Slaves are 5.x. Hopefully I've figured out the issue. When t

Re: Replication Falls Out Of Sync With LOAD DATA

2007-11-28 Thread B. Keith Murphy
The reason I asked about version is that it looks like there is problem replcating a load data infile command from some versions of 4.x to 5.x slaves. Baron Schwartz wrote: What do you mean by "falls out of sync?" LOAD DATA INFILE hasn't been a problem for me, and I use it a LOT. It's so sim

Re: Replication Falls Out Of Sync With LOAD DATA

2007-11-28 Thread Baron Schwartz
What do you mean by "falls out of sync?" LOAD DATA INFILE hasn't been a problem for me, and I use it a LOT. It's so simple that I suspect something else. But then again, I don't know what you mean by "out of sync" :) On Nov 28, 2007 4:32 PM, B. Keith Murphy <[EMAIL PROTECTED]> wrote: > What vers

Re: Replication Falls Out Of Sync With LOAD DATA

2007-11-28 Thread B. Keith Murphy
What versions of MySQL are you using on both the master adn the slaves? Keith Michael Stearne wrote: We have replication set up for 1 master and 4 slaves. When resynced everything appears to work fine. Come back a couple hours later and the machines are out of sync. The only thing I can think

Replication Falls Out Of Sync With LOAD DATA

2007-11-28 Thread Michael Stearne
We have replication set up for 1 master and 4 slaves. When resynced everything appears to work fine. Come back a couple hours later and the machines are out of sync. The only thing I can think of that could cause this is that we are inserting some data on the master (updates,inserts,deletes