Background
We have a live app with several thousand users, and I recently found out that a certain data object is missing from the database, and it is used as a common template object referenced by every user!
So it’s missing has definitely broken some functionality.
Ideal solution
It has now been almost a week since it disappeared. I would like to backup the database to before that occurred, but there are many other data records that I would like to keep so users don’t lose the last week of their work stored in the app!
Request for input
Any recommendations on how I could export data from the last week, restore the database to before the data loss, and then bring back in the last week of data?
If I 've missed any obvious ways to do this I apologize in advance and any guidance to the right spot for documentation would be greatly appreciated