SAbboushi
asked on
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.ROUTINE S, 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
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.ROUTINE
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.