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.