Re: Errors with Information_Schema in Create Target Results

[Peter Brawley]

> 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.