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 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 of that could > > cause this is that we are inserting some data on the master > > (updates,inserts,deletes) using LOAD DATA INFILE. Does this cause a > > problem for replication? > > > > Thanks, > > Michael > > > > > -- > Keith Murphy > > > editor: MySQL Magazine > http://www.mysqlzine.net > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]