In Which Location Are Mysql Compiled Procedures Stored?

Question

How can I get compiled Mysql stored procedures from their physical location?

Answer 1

In the database mysql there's a table proc which seems to hold all the data for a stored procedure.
So the physical files should be <datadir>/mysql/proc.MYI and <datadir>/mysql/proc.MYD.

edit: But maybe you're simply looking for SHOW CREATE PROCEDURE?