Re: View pocedures/backup procedures

[Dan Nelson]

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@stripped