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.