Database Restore - without losing recent data

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 :broken_heart: some functionality.

Ideal solution
It has now been almost a week :grimacing: 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? :heart_eyes:

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