From: Dan Nelson
Date: March 26 2009 3:12pm
Subject: Re: where is the stored functions STORED?
List-Archive: http://lists.mysql.com/mysql/216902
Message-Id: <20090326151246.GB62664@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Mar 26), Cui Shijun said:
>   It seems that the stored functions isn't stored in a seperated file
> like trigger does.
>   Where are them?
>   If I copy the database directory from a server to another, can I get
> the same functions on the both servers?

They're stored in the mysql.proc table.  If you're only copying one
database, it might be easier to use "mysqldump --no-create-info --no-data
--routines mydb" , which will give you the commands to recreate the stored
procedures for the mydb database.

-- 
	Dan Nelson
	dnelson@stripped