MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:July 26 2004 1:20pm
Subject:RE: Replication script pb
View as plain text  
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()

-----Original Message-----
From: Philippe Poelvoorde
To: mysql@stripped
Sent: 7/26/04 7:03 AM
Subject: Replication script pb

Hi,

We have an environnment with a master and a slave. We run a script every

hour (on the master only) that does something like this to backup some 
parameters :
insert into backup(NULL,NULL) VALUES(NULL,NOW())
SET @backup_id = @@LAST_INSERT_ID
INSERT INTO backup_param ( SELECT @backup_id, col1, col2 FROM param)
It works perfectly on the master but the slave stop due to duplicate 
entries. the @backup_id do not pass the replication...
any solution to have that script working ?

-- 
Philippe Poelvoorde
COS Trading Ltd.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
Thread
Replication script pbPhilippe Poelvoorde26 Jul
RE: Replication script pbVictor Pendleton26 Jul
  • RE: Replication script pbPaul DuBois27 Jul
    • Re: Replication script pbPhilippe Poelvoorde27 Jul
      • Re: Replication script pbPaul DuBois27 Jul
RE: Replication script pbVictor Pendleton27 Jul
  • Re: Replication script pbPhilippe Poelvoorde27 Jul
RE: Replication script pbVictor Pendleton27 Jul
  • Re: Replication script pbPhilippe Poelvoorde27 Jul