SP generally goes as per the database you have created. Set you binlog off while creating for the sql.
sql_log_bin is the variable to do it. On Tue, Jun 8, 2010 at 1:01 AM, Sabika Gmail <sabika.makhd...@gmail.com>wrote: > I already have mysql in the replicate wild ingore table. I am running mysql > 5.1.40sp1 > > Could it be a bug? > > > On Jun 7, 2010, at 8:30 AM, Rolando Edwards <redwa...@logicworks.net> > wrote: > > I think this is normal because stored procedures live in mysql.proc. >> >> You would have to filter out mysql.proc by adding this to /etc/my.cnf >> >> replicate-ignore-table=mysql.proc >> >> Rolando A. Edwards >> MySQL DBA (CMDBA) >> >> 155 Avenue of the Americas, Fifth Floor >> New York, NY 10013 >> 212-625-5307 (Work) >> 201-660-3221 (Cell) >> AIM & Skype : RolandoLogicWorx >> redwa...@logicworks.net >> http://www.linkedin.com/in/rolandoedwards >> >> >> -----Original Message----- >> From: Sabika Gmail [mailto:sabika.makhd...@gmail.com] >> Sent: Monday, June 07, 2010 11:14 AM >> To: mysql@lists.mysql.com >> Subject: Replication of MySQL Stored Procedure >> >> Hi! >> >> I have a database in the wild ignore table as table.%. Recently I >> created a store procedure on it and it replicated. Does any one know >> if this is normal bahvior? If I wanted to make sure store procedures >> do not replicate, what should I do? >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net >> >> > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com > > -- Thanks Suresh Kuna MySQL DBA