Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
ojaidave Posted Friday at 11:42 PM Posted Friday at 11:42 PM 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 yesterday at 02:31 AM Posted yesterday at 02:31 AM 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 18 hours ago Posted 18 hours ago 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