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

Written By
Backup and restore for views
March 15, 2022 08:02AM
March 15, 2022 11:23AM

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.