Re: Errors with Information_Schema in Create Target Results
Posted by: Peter Brawley
Date: October 24, 2021 03:48PM

> trying to "clone" our production server in a lab environment

If it's me, for a job like that I want as little software as possible between me and what I'm doing, so I use mysqldump to make a logical backup of the entire server, eg from a cmd window in the mysql installation bin directory ...

mysqldump –uUSR –pPWD –K –E –A –R –f >some_backup_dir/mybackup.sql

... and I import that into the desired MySQL instance.

Options: ReplyQuote


Subject
Written By
Posted
Re: Errors with Information_Schema in Create Target Results
October 24, 2021 03:48PM


Sorry, only registered users may post in this forum.

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.