copy procedure

Have a proc in one db and want to make same in another.
In first I can copy create code, and now ?
Can't find a way to paste that somewhere and execute in another db.

Just use the "Export database" dialog: Set output to "Database" and select target database below.

Thanks. Was playing with that but was not going anywhere until you extra told me (-:

This option works perfect!

But i cannot understand Why copying the code doesn't work!

anse:
After a few test, could you add this in the procedure code:
DELIMITER //
CREATE DEFINER .......
.....
END //
DELIMITER ;

With this extra code at the beginning and at the end, everything works fine!

The DELIMITER is not part of the code physically required for creating the procedure, so it should not be contained in the "CREATE CODE" tab. For this purpose, HeidiSQL has a button (the one on the main toolbar with the red semikolon on it). If that was part of the CREATE CODE, that would also *implicitely* kill any delimiter you have set before via that button. That's not a good idea.

I tried what you told me in the previous meessage. Now, i understand!

I think you're right related to the CREATE CODE, but, i wonder Why don't you add this "extra" feature as an option, becasue i think it doesn't cost su much adding this as an option!

The "make it optional please" argument is such overstressed already, it's used for just every feature request which does not make sense in many users eyes.

But apart from that, as said above: If the delimiter was part of the CREATE CODE, that would also *implicitely* kill any delimiter you have set before via that button.