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.