Copy stored procedure from one db to another in php

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

Check this http://stackoverflow.com/questions/1968773/view-stored-procedure-function-definition-in-mysql#answer-1968798 — Aman Rawat, May 03 '17 at 07:50
Possible duplicate of [View stored procedure/function definition in MySQL](http://stackoverflow.com/questions/1968773/view-stored-procedure-function-definition-in-mysql) — NetVicious, May 03 '17 at 08:26

score 2 · Accepted Answer · answered May 03 '17 at 07:53

2

I hope this helps.

SHOW CREATE PROCEDURE DB_Name.Procedure_Name;
use New_DB_Name

create procedure again.

answered May 03 '17 at 07:53

Faizan Younus

793
1
8
13

Copy stored procedure from one db to another in php

1 Answers1