I use MySQL Browser
When I store a procedure, I find an entry for that procedure in the Schemata pane under the db name it was associated with.
I can right click on it and see the complete ORIGINAL statement that was used to create the stored procedure, including any statements like Delimiter and Drop Procedure BEFORE the create procedure statement as well as AFTER the BODY of the procedure.
I know I can get a copy of the procedure BODY from information_schema.ROUTINES, but where is the rest? And how can I back up (as in MySQL Adminisrator backup routine) the entire stored procedure that I see when I right click on the procedure name in MySQL Query Browser and select 'Edit Procedure'?
Note: The MySQL Administrator allows me to edit the stored procedure which includes the Create statement, but omits the Delimiter and Drop Procedure statements.