I need to make a php script that can copy stored procedure and function from one database to another, how can i do this ? The database is mysql and there 2 database are not on the same server
I hope this helps.
SHOW CREATE PROCEDURE DB_Name.Procedure_Name;
use New_DB_Name
create procedure again.