MySQL Forums
Forum List  »  MySQL Workbench

Migrate ONLY Stored procedures (w/o deleting data)
Posted by: A. Aquiles
Date: April 10, 2018 05:23AM

Help appreciated.
I have 2 servers (DS1, DS2) with 2 almost identical databases (DBX on DS1, DBX1 on DS2). I would like to copy the Stored Procedures from DBX on DS1 to DBX on DS2, using mySQL Workbench.

I have ALREADY copied the tables (using Server >Data export > dump tables to folder), all completed OK. I have noticed that if you try to copy the Stored procedures AFTER the tables migration, sometimes recreates the tables, so you lose all migrated content.

How can I migrate *only* the SPs, without crashing or deleting the tables in the target database?

My question is about WHICH method (since you can do Server>Data export, but you can also do Database > Migration wizard), but also about the parameters (I assume one of these methods has a checkbox that allows copying w/o deleting?).


Options: ReplyQuote

Written By
Migrate ONLY Stored procedures (w/o deleting data)
April 10, 2018 05:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.