MySQL Forums
Forum List  »  Data Recovery

Re: Views not correctly exported to dump file
Posted by: JK Heydt
Date: April 12, 2022 08:33AM

Found the problem: When I replaced the database name in the dump file with a new name, I didn't replace all the instances. I missed some instances at the bottom where views were created.

Turns out all dump file views are originally created with a 1 AS 'Fieldname' syntax and then replaced with the correct syntax. I didn't realize that so I thought it was a bug.

Thank you Peter Brawley for helping with this issue.

Options: ReplyQuote

Written By
Re: Views not correctly exported to dump file
April 12, 2022 08:33AM

Sorry, you can't reply to this topic. It has been closed.

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.