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 -- Siemens AG ITO A&S 4 Internetteam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
