The Arcive of Official vBulletin Modifications Site.

xtrememods · #1 07-10-2003, 03:07 PM

Right guys, I've already scanned through these here forums for an answer to my problem, and have tried some of the scripts here, but I just can't seem to get it to work.

Recently I pruned me forums without realising what I was doing. And doing this, I've deleted a lot of important threads and posts. I have a backup of my forums from two days ago, and basically I would like to pull all user, threads, posts etc from the old backup, and insert it back into the existing database.

If anyone can help, I would be prepared to pay to get this sorted.
Thanks in advance.

N!ck · #2 07-10-2003, 04:17 PM

Just drop your whole database and restore it using the backup .sql file. Make sure it has the CREATE TABLE xxxxx junk in it though, because I'm not 100% sure.

xtrememods · #3 07-10-2003, 04:44 PM

Erm, that kinda isn't any help at all, sorry, all that does is replaces the existing database with the old one, therefore it will not contain data from the existing one. So it's kinda pointless in me doing that, as I loose the data that I wish to keep from the new one. Thanks for your post though.

Gavin B. · #4 07-10-2003, 04:47 PM

ohh - messy

I'm trying to think of the most efficiant way to do this - maybe if you export all the posts/threads/attachments from the backup (only the ones which you pruned though!) and then import them into the new database. Not 100% on that solution though.

There may me a database sync. tool which allows you to compare/add/update two database's but I don't know of one offhand.

xtrememods · #5 07-10-2003, 08:53 PM

Thanks for the help guys, but all is fixed now. A good friend of mine who is experienced with MySQL has manually inserted ALL the data, and it all works! Thanks for your help though.

N!ck · #6 07-11-2003, 03:49 AM

Quote:

Today at 10:44 AM xtrememods said this in Post #3
Erm, that kinda isn't any help at all, sorry, all that does is replaces the existing database with the old one, therefore it will not contain data from the existing one. So it's kinda pointless in me doing that, as I loose the data that I wish to keep from the new one. Thanks for your post though.

Since you responded so rudely and condescendingly, I'll make it a point to offer you no advice in the future, even when I have clearer solutions in mind.

base · #7 07-11-2003, 03:07 PM

i dont see that as being rude, in fact, he was quite polite to you.

Gavin B. · #8 07-11-2003, 03:17 PM

Yeah, don't take it the wrong way- I think he was just being a bit blunt. I doubt he meant to come across as rude

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03889 seconds Memory Usage 2,225KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (8)postbit (8)postbit_onlinestatus (8)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!