Re: Errors with Information_Schema in Create Target Results

[Vaughan Wickham]

Peter Brawley Wrote:
-------------------------------------------------------
> You have another instance of MySQL 5.7.18
> installed on anther machine?

Yes, sorry I should have stated that explicitly for clarity.

> If so, you'll want to copy the mysqldump file into
> a convenient folder on the machine where your new
> MySQL instance is.
>
> Then assuming the file is backup.sql in some_path,
> invoke mysql client program with your username and
> password and the show_warnings option ...
>
> mysql -uUSR -PWD --show-warnings
>
> ... then type ...
>
> source some_path/backup.sql
>
> (note, no terminating semi-colon).

I'd like to create a cmd file to perform the restore, so once I have the syntax worked out there is no possibility of me stuffing up the arguments

Can I do the above in a cmd file, and then just be prompted for the PWD interactively?

Can I redirect the warnings to a text file?

The OS is Windows