MySQL Forums
Forum List  »  Backup

Backup and restore for views
Posted by: Martie Henry
Date: March 15, 2022 08:02AM

I make extensive use of views in my database, more views than tables.
No idea how the backup is handling views, but restore restores the views as tables, with data!
This is not how it should work.
A view is basically just a stored query, certainly not a table.

Since it’s screwed up, how can I backup everything except views? Then I could restore just that.

Easy enough to save just the view definitions separately, and then to restore, execute the view definitions after everything else.

Please help. I have 267 tables and 467 views.

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup and restore for views
230
March 15, 2022 08:02AM
109
March 15, 2022 11:23AM


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.