Backing Up Stored Procs
Hi,
I have noticed with MySQL Administrator when I backup stored procs they
never restore properley.
Re: Backing Up Stored Procs
Jared wrote:
> Hi,
>
> I have noticed with MySQL Administrator when I backup stored procs they
> never restore properley.
Read about the --routines option to mysqldump here:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
There doesn't seem to be an equivalent GUI control in MySQL
Administrator for this option. For now, you'll have to do it at the
command-line if you want stored procs to be backed up.
http://bugs.mysql.com/bug.php?id=16784
It appears to be an "In Progress" bug. You might want to add yourself
to the watch list for this bug, so you'll be notified when it's fixed.
Regards,
Bill K.
Re: Backing Up Stored Procs
Thanks - now watching this bug as well.