Re: Errors with Information_Schema in Create Target Results
Posted by: Vaughan Wickham
Date: October 26, 2021 10:01PM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: Errors with Information_Schema in Create Target Results
October 26, 2021 10:01PM


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.