vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   loading certain tables from previous backup (https://vborg.vbsupport.ru/showthread.php?t=152195)

feras 07-14-2007 05:49 AM

loading certain tables from previous backup
 
Hi,
I setup my server to take cpanel backups of my board weekly.
Anyways, long story, buy 1 of the admins deleted all the threads in 1 of the forum section.

I've reloaded the backup on a different location (so it doesnt overwrite the current site, since there's alot of new content and what not) and am logged into the admincp in the backup

Is there anyway to copy over just those forums, or anything of that nature?
thanks

Dismounted 07-14-2007 06:11 AM

The only way would probably be to go into the backup's text and remove everything apart from those entries.

feras 07-14-2007 06:18 AM

dismounted, I didnt quite understand what you meant.

The backup has an older version of the site, but it has the posts in the forum that got emptied.

The current site doesnt have the posts in that forum, the forum is blank.

So in essence, I'm trying to put just those posts from the backup into the current forum.

Also, I'm pretty good at coding and would probally understand most of what you say if you get technical. I could do this custom, but I'd have to code alot, check ids, etc, isnt easy work.

thanks

Dismounted 07-14-2007 06:43 AM

Open up the SQL backup in a text editor and you'll see ;).

feras 07-14-2007 07:29 AM

it's basically a mysql dump correct? All the create tables and inserts?

It wouldnt be that easy to distinguish what I need and what I dont. There has to be something pre-written to help me do this

Dismounted 07-14-2007 10:37 AM

Search for one of those MySQL restore scripts, they probably have a parsing feature.


All times are GMT. The time now is 04:46 PM.

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.01175 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
  • (6)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