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

Possible duplicate of View stored procedure/function definition in MySQL — NetVicious
– NetVicious, Commented May 3, 2017 at 8:26

Faizan Younus · Accepted Answer · 2017-05-03 07:53:15Z

2

I hope this helps.

SHOW CREATE PROCEDURE DB_Name.Procedure_Name; use New_DB_Name

create procedure again.

answered May 3, 2017 at 7:53

Faizan Younus

8031 gold badge9 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Copy stored procedure from one db to another in php

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related