Copy PROD db's to TEST db's
Posted by: Kevin Smee
Date: April 27, 2021 08:31AM

I have a MySQL PROD db that is replicated (PROD1 and PROD2, respectively) that I would like to copy (overwrite) to my TEST instance db; also replicated (TEST1 and TEST2). I was thinking of using the MySQL Workbench's Migration Wizard for this. The replication piece has me concerned as to the best - and simplest - way to do this. My thought was to stop the MySQL services on TEST and set the Wizard option to truncate the tables in TEST1 and TEST2. Looking for advice. Thanks!

Options: ReplyQuote

Written By
Copy PROD db's to TEST db's
April 27, 2021 08:31AM

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.