On Tue, Jan 15, 2002 at 10:59:07PM -0500, Wendell Dingus wrote: > > I'm fairly certain this is a bug. It's on 3.23.46-max and the > changelog for .47 doesn't mention it. > > I have 2 servers using replication. Server1 is used by client > machines and all updates are to it. Server2 stays in perfect sync > with it and logs all updates to it's own binary log. I then use > mysqlbinlog from server2 to parse out those database changes every > half hour or so and send to another server via a (part-time) > internet connection where it attempts to maintain a synced copy of > the data as well. A "modify table" to add a new field on server1 > propogates to server2 but NOT to the third server. I've not tracked > down exactly where things are breaking down yet. Server1 and 2 are > Linux and are using INNODB tables. Server3 is not Linux and is not > able to use INNODB at the moment. Even a "create table > ... type=INNODB" works on server3 making the table MyISAM > instead. It's just the modify table statements with the addition of > a new field that don't make it. > > I've not captured and analyzed one of the binary logs yet but will > try to do so. Just wanted to let someone know of a probable > bug. I'll also upgrade to .47 and report back if that resolves this.
But you can see the query in the binary log? Is it just a case of mysqlbinlog not extracting the query properly? Jeremy --------------------------------------------------------------------- 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