ojaidave Posted November 15 Posted November 15 A user who was an admin for a time and still had admin rights deleted their posts - not out of spite, just wanted to fade away. The problem that they didn't consider when they hit the "delete my content" button is that they had started a number of topics over the years that were popular and evergreen. They didn't mean to nuke the board, and it took a day for me to realize what had happened. In the Moderator or Admin CP's, no deleted post show up. I suppose I could restore the complete database from three days ago, but is there anyway to be more surgical with my recovery or will I simply lose 3 days worth? It's a small board, with not a whole lot of members, but the amount of posts deleted is massive.
teraßyte Posted November 16 Posted November 16 To restore only those specific posts you'd need to write a script for it, restore the old database in another location, and be sure to re-insert the posts with the same ID and update many other tables. Honestly, since you already mentioned the site is small and has few members, restoring a backup from 3 days ago is better and far easier. 🤷♂️
Jim M Posted November 16 Posted November 16 Yeah, as Terabyte mentioned, the only way would be to surgically add all the table rows and references back in, ensuring none are missing (if any are missing, you will get errors). Note: we do not support this kind of custom restore and any issues which result from it would be outside of scope as well. The easiest and cost-effective way to do this would be just to restore a full backup.
Recommended Posts