Re: stored procedures and functions

[Andrew Blake]

Hi

What works for me is to use the --routines option in the mysqldump command that sets up the slave server.

That is, when I first set up the slave server, I do a mysqldump of the master server with the following options (as well as the regular connection options):

--quick --skip-comments --master-data --single-transaction --add-drop-database --all-databases --routines

This causes mysqldump to output the "create procedure" and "create function" queries that originally created the procedures and functions, rather than in the form of inserts to the mysql.proc table.

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

Hope that helps