Re: Errors with Information_Schema in Create Target Results
Posted by: Peter Brawley
Date: October 27, 2021 07:16PM

> Warning (Code 3135): 'NO_ZERO_DATE',

Yes, you'll need to adjust such settings on the target system.

> ERROR 1231 (42000): Variable 'time_zone' can't be set to the value of 'NULL'

If you examine the output of mysqldump, you'll see that such variales are st at the top, restored at the bottom. You'll need to investigate how your dump file came to lose thioe settings.

> the size of the mysqldump from the Lab system is just under 600MB versus
> the size of the mysqldump from the production server which is 7.9GB

Perhaps the same problem---the dump file is incomplete. Only you can find out how that happened.

If it's me, I try this job one database at at time.

(You're learning why trying to one-click such a job isn't feasible.)



Edited 1 time(s). Last edit at 10/27/2021 07:17PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: Errors with Information_Schema in Create Target Results
October 27, 2021 07:16PM


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.