Jeff, Egor, Guilhem Bichot just found a bug in replication of LOAD DATA LOCAL INFILE in 4.0.
The problem is the LOCAL keyword. Of a large import file, only 8 kB or 16 kB will actually be replicated in the slave. Do you use the LOCAL keyword? I do not know if the bug affects 3.23. Are you using selective replication of some tables or databases? If yes, check also that your LOAD DATA INFILE is not excluded by these rules. Regards, Heikki Innobase Oy sql query ............. Subject: re: BUG? 3.23.55 not replicating LOAD DATA INFILE From: Egor Egorov Date: Thu, 20 Feb 2003 14:07:02 +0200 On Thursday 20 February 2003 01:04, Jeff Kilbride wrote: > I have one master and two slaves all running 3.23.55-max on RedHat 7.3. > I've had replication up and running smoothly for several days. Today, I > decided to try out LOAD DATA INFILE on the master. After successfully > loading on the master, I checked both slaves and neither one had the new > data. There are no errors in any of the log files and both slaves are still > replicating correctly. Only the LOAD DATA info is missing on the slaves. I > have the slow query log running on the master and the LOAD DATA statement > showed up there: > > # Time: 030219 17:09:02 > # User@Host: root[root] @ localhost [] > # Query_time: 34 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 > SET timestamp=1045692542; > load data infile '/home/jschaffe/stro0002.txt' > ignore > into table list > (email); > > Are there any settings in my.cnf that would affect this? The manual says: > > "In 3.23, LOAD DATA INFILE will be handled properly as long as the file > still resides on the master server at the time of update propagation." > > When exactly is the "time of update propagation"? I'm assuming this is > immediately, like all other replication tasks. The file still resides on > the master, right now, but the slaves still haven't received the data. Is > this a bug or am I missing something? Here are the server settings from > my.cnf on the master: Hm .. I tested LOAD DATA INFILE with replication and it works for me .. What is your slave replication options in my.cnf? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
