In the last episode (Jul 10), Andrey Dmitriev said:
> How do I view and backup my procedural code?
>
> In oracle it would be something like
> Select text from user_source where name='MY_PROCEDURE' order by line;
>
> I did mysqldump, and didn't see any of the functions or procedures
> created.
>
> In Oracle they'd be backed up either via RMAN or EXP.

You need to add the --routines flag to mysqldump.

--
Dan Nelson
dnelson@allantgroup.com