Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 18 Jul 2011, 15:13
voter's Avatar
voter voter is offline
Join Date: Dec 2006
Question Recover/restore deleted attachments - Parial Database restore

Login of one of our users is misused and all attachments are deleted via usercp->attachments (profile.php?do=deleteattachments).

We have the attachments on file system, so all attachments are physicall there and only information in database is lost.

We have the database backup before the deletion happend, but we localize the porblem already to late, there are many days and lot of new posts and changes are happened in forum since the incident. So simple rollback and database recovery with losing all new posts are out of discussion.

I would be thankful for help to find a steps how to extract necessary information from old database and merge it into new one.

So the main problem is how to recover information in database about attachments?

I am sure that simply merging/recovering data in database table "attachments" only will not be enough, as of attachments have been inserted into posts and corresponding posts must be recovered too.
Reply With Quote
Old 23 Jul 2011, 00:44
Videx's Avatar
Videx Videx is offline
Join Date: Feb 2007
Super Major Project. I wouldn't touch it. I can only see real chaos resulting. Either restore the whole db or forget it. IMHO, of course.
Reply With Quote
Old 24 Sep 2015, 14:30
kartik786 kartik786 is offline
Join Date: Aug 2005
Okay I'm having a similar situation here :

Can anyone help? OP were you able to do this?
Reply With Quote

Similar Threads
Thread Thread Starter Forum Replies Last Post
End-User Options Restore A Deleted Member ra7al vBulletin 3.6 Add-ons 30 08 Oct 2012 00:35

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 00:03.

Layout Options | Width: Wide Color: