Dear Nilnandan, Thanks for the quick reply. But this particular variable is not working in only one proc call...but rest all procedures creating temporary tables, does not affect my replication slaves. So I am not able to identify the problem. Here's the snapshot of my procedure which is causing a problem. Drop Temporary Table If Exists norep_Temp3; Create Temporary Table norep_Temp3 ( UserID BigInt, FirstName Varchar(45), LastName Varchar(45)
); Insert into norep_Temp3(UserID, FirstName, LastName) Select UserID From tbl1; Update norep_Temp3 T3, tbl2 Set T3.FirstName = tbl2.FirstName, T3.LastName = tbl2.LastName Where T3.UserID = tbl2.UserID; Insert into MyTbl(UserID, Name) Select UserID, Concat(FirstName,' ',LastName) From norep_Temp3; -- Regards, Manasi Save On Wed, 23 Jun 2010 18:47:19 0530, Nilnandan Joshi wrote: Hi Manasi, > > Please try with this one. > Replicate_Wild_Ignore_Table = mydb\temp_.% > > Regards, > Nilnandan Joshi > > Manasi Save wrote: > > Hi All, > > > > I have kept > > Replicate_Wild_Ignore_Table = mydb%.temp_% > > > > this is temporary table which i want should not be replicated. But > > still it is getting replicated and slave is getting crashed. > > > > > > any input will be a great help. > > > > -- > > Thanks and Regards, > > Manasi Save > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
