Hello.
It seems like a documented bug. Switch to 4.1.12. See: http://dev.mysql.com/doc/mysql/en/replication-features.html Markus Benning <[EMAIL PROTECTED]> wrote: > Hello, > > i have a problem with my replication setup and SET statments. > The SET statments seem to be not logged with the queries. > > An example: > > CREATE TABLE blablub (ID INT NOT NULL auto_increment PRIMARY KEY, bla text, > blub text); > SET @bla='bla'; > SET @blub='blub'; > INSERT INTO blablub VALUES(NULL, @bla, @blub); > > Now the table blablub on the Master: > > +----+------+------+ > | ID | bla | blub | > +----+------+------+ > | 1 | bla | blub | > +----+------+------+ > > And on the Slave: > > +----+------+------+ > | ID | bla | blub | > +----+------+------+ > | 2 | NULL | NULL | > +----+------+------+ > > Here's the binlog entry for the INSERT: > > #050624 16:46:54 server id 1 log_pos 9162 Intvar > SET INSERT_ID=1; > # at 9190 > #050624 16:46:54 server id 1 log_pos 9190 Query thread_id=7 > exec_tim > e=0 error_code=0 > SET TIMESTAMP=1119624414; > INSERT INTO blablub VALUES(NULL, @bla, @blub); > > > Same should happen when the binlog is replayed while restoring a backup. > I'm using mysql release 4.0.24. > > regards, > Markus -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
