Backing Up Stored Procs

Hi,

I have noticed with MySQL Administrator when I backup stored procs they
never restore properley.
Jared [ Di, 27 Juni 2006 00:37 ] [ ID #1370532 ]

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.
Bill Karwin [ Di, 27 Juni 2006 04:07 ] [ ID #1371934 ]

Re: Backing Up Stored Procs

Thanks - now watching this bug as well.
Jared [ Di, 27 Juni 2006 05:43 ] [ ID #1371935 ]
Datenbanken » mailing.database.mysql » Backing Up Stored Procs

Vorheriges Thema: Simple MySQL Search from MySQL beginner
Nächstes Thema: NOW() in inserts updates implicitly