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=arch...@jab.org

Reply via email to