Re: copy stored procedures

[Devart Team]

>in this way, the SPs are effectively copied over to targetSchema..
That is a solution.

Also, in script you could do sometning like this -

SET @source_db = 'database1';
SET @target_db = 'database2';

SELECT * FROM mysql.proc WHERE db = @source_db
INTO
  OUTFILE 'proc.csv'
  FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n';

LOAD DATA INFILE 'proc.csv' INTO TABLE mysql.proc FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' SET db = @target_db;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/



Edited 1 time(s). Last edit at 06/10/2010 07:38AM by Devart Team.