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
Subject
Views
Written By
Posted
2075
February 03, 2012 02:14AM
1116
March 07, 2012 02:34PM
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.