From: Dan Nelson
Date: July 11 2007 12:58am
Subject: Re: View pocedures/backup procedures
List-Archive: http://lists.mysql.com/mysql/207993
Message-Id: <20070711005856.GA2659@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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