I feel for you. I almost lost 10+ years of my wordpress database a couple years ago and it was a horrifying thought. Luckily I’m kinda nuts about backups and even though they had the same error the database itself was okay.
In a way you can think of it as a great success that you’ve lost count of how much you’ve produced! I would qualify it as such 👏🏼👏🏼