Is there any reason why a replicating master won't write some incoming write-queries to the binlog for slaves to pick up? I have a php script which dynamically builds an sql string and sends it to mysql - the query works fine, the data is inserted, but it's never written to the binlog as long as it's sent to mysql from that particular php script. If I paste the static sql string into another php script on the same server, and use the php mysql_query() function, it performs the insert, and it gets logged to the binlog for the slaves to pick up on. If I paste the sql string into the original script and use a simple mysql_query() to send it to mysql, the query executes successfully, but is still not written to the binlog. Most peculiar. It looks like there's some condition in that single situation where, for some reason, the query isn't logged to the binlog - I'm just hoping someone knows of special circumstances where this is the case. In the meantime, I'm going to keep trying to find out why it's happening. Jason --------------------------------------------------------------------- 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
