• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 663
  • Last Modified:

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
0
SAbboushi
Asked:
SAbboushi
1 Solution
 
UmeshCommented:
>>>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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now