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
