MySQL Query Browser & Where is stored procedure stored?

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.

With Regards-
Sam
SAbboushiAsked:
Who is Participating?
 
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
>>>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'?

Check out the mysql.proc table and you would see all the details related to the stored procedure..
Also, when you backup the database using any GUI tools or any commandline utlitities such as mysqldump.. you would notice that the dump tool exports the procedure details as well.

From MySQL Administrator GUI client.. you can just export the schema contaning the storedure and you will see the procedure details in the dmp file.

From commandline client such as "mysqldump... stored procedures are exported with the parameter --routines which is default.

0
 
SAbboushiAuthor Commented:
>> Check out the mysql.proc table and you would see all the details related to the stored procedure..
I find that the mysql.proc table contains the CHARACTERISTICS of the routine - but not the body nor the create statement nor the other statements I've asked about above

>>when you backup the database using any GUI tools
Thanks, but I am asking about backing up JUST the procedures

>>From MySQL Administrator GUI client.. you can just export the schema contaning the storedure and you will see the procedure details in the dmp file.
Thanks!  This is what I wanted.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.