Is it possible to run replication on tables that are updated with user vars?
Example: SET @id = 1; <<<< does not show up in binlog!! INSERT INTO table SET id = @id; Now, on the master it works fine. The slave fails because the SET does not seem to show up in the binlog, @id is not set, and the 'id' field may not be null. Sql, cache, query, peanutbutter --------------------------------------------------------------------- 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