vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Recover/restore deleted attachments - Parial Database restore (https://vborg.vbsupport.ru/showthread.php?t=267030)

voter 07-18-2011 02:13 PM

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.

Videx 07-22-2011 11:44 PM

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 09-24-2015 12:30 PM

Okay I'm having a similar situation here : https://vborg.vbsupport.ru/showthread.php?t=320335

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


All times are GMT. The time now is 09:00 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01173 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete