在php中将存储过程从一个db复制到另一个db

Question

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

Answer 1

I hope this helps.

SHOW CREATE PROCEDURE DB_Name.Procedure_Name;
use New_DB_Name

create procedure again.