vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=267030

Recover/restore deleted attachments - Parial Database restore
by voter
18 Jul 2011 15:13

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.

Videx 23 Jul 2011 00:44

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.

kartik786 24 Sep 2015 14:30

Okay I'm having a similar situation here : http://www.vbulletin.org/forum/showthread.php?t=320335

Can anyone help? OP were you able to do this?


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

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.