MySQL Forums
Forum List  »  Replication

Re: stored procedures and functions
Posted by: Irfan Ali
Date: March 08, 2012 04:23AM

>> I don't know why it doesn't work without the "--routines" option, but it does seem to work if you use it.

By default, mysqldump not backup stored functions. You need to pass --routine flag explicitly to mysqldump command in order to dump SP.

Also, mysql replication replicates stored procedures and functions.
You can check the following URL to know how binary logging works for stored programs.

http://dev.mysql.com/doc/refman/5.0/en/stored-programs-logging.html

Show me mysql replicatoin format you are using.
my.cnf replication stuff for master / slave
mysql versions on master / slave

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: stored procedures and functions
1048
March 08, 2012 04:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.