MySQL Forums
Forum List  »  Data Recovery

Re: Views not correctly exported to dump file
Posted by: Peter Brawley
Date: April 11, 2022 09:02PM

Quote

Either way I get the same result: a Temporary view structure for view `vw_charges` with 1 AS ... and a Final view structure for view `vw_charges` that has the correct create syntax.

Why mySQLdump writes this "temporary" or preliminary view def, I can only guess. The important point is, though, that it drops it before creating the actual View.

Why doesn't mysqldump do so when called by the third-party batch file? I think the most likely cause would be a privilege issue, ie something to do with how %dbuser% is populated. Only you have access to this, so you'll have to experiment with it to find out what's going



Edited 1 time(s). Last edit at 04/11/2022 09:29PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Views not correctly exported to dump file
71
April 11, 2022 09:02PM


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.