Yup, don’t dump the database, just shuffle the primary keys on important tables. Systems keep running, so it takes longer to work out what’s wrong, and the data gets even more screwed up with every passing transaction. You very rapidly end up with a basically unrecoverable mess if you’re also talking to external systems, as none of their data will match yours anymore, even if you do try to recover from an older backup.