Re: Errors with Information_Schema in Create Target Results

[Vaughan Wickham]

Peter Brawley Wrote:
-------------------------------------------------------
> Could you give some context? What exactly are you
> migrating from?

Hello Peter,

I'm trying to "clone" our production server in a lab environment. So that I can use the lab system to practice database backup and restore.

I've inherited responsibility for the production server and I've not had any experience with MySQL

> And you're using 5.7.18, why not the latest 5.7?
> Or 8.0?

Two reasons

1. 5.7.18 is the version of the production server, so it makes sense to be on the same version in the lab

2. Ironically I tried installing v8 initially but could not resolve this issue
https://forums.mysql.com/read.php?104,699413,699413#msg-699413