Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2004, 10:07 PM
jcr jcr is offline
 
Join Date: Apr 2004
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Extremely urgent, please help!

I managed to delete my hole board today, I took a backup yesterday, but I dont have the tables set up correctly. Does someone have the correct mysql tables for 3.0.1 ?

I'm about to cry.. as a few thousand new posts was made today
Reply With Quote
  #2  
Old 07-20-2004, 10:21 PM
nexialys
Guest
 
Posts: n/a
Default

the basic tables are included in the default install... what to do is simple: install a default vBulletin, and use these tables to rebuild your backup...
Reply With Quote
  #3  
Old 07-20-2004, 10:22 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm ... if you reload the backup it should re-create all tables.
Reply With Quote
  #4  
Old 07-20-2004, 10:24 PM
jcr jcr is offline
 
Join Date: Apr 2004
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by nexialys
the basic tables are included in the default install... what to do is simple: install a default vBulletin, and use these tables to rebuild your backup...
Hmm. that might just work. I have to create a new database, since I've already begun uploading parts of the functioning existing database. I miss only a few tables :-/ But hey.. thanks! I see a light in the tunnel now.
Reply With Quote
  #5  
Old 07-20-2004, 10:26 PM
jcr jcr is offline
 
Join Date: Apr 2004
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by KirbyDE
Hmm ... if you reload the backup it should re-create all tables.
Mine didn't :-S , it backed up only portions :-/ I only made a dump of the content not the parameters :-/
Reply With Quote
  #6  
Old 07-20-2004, 10:28 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's bad luck

Di you have complete inserts in your sql file?
Then you would at least know all column names.
Reply With Quote
  #7  
Old 07-20-2004, 10:39 PM
jcr jcr is offline
 
Join Date: Apr 2004
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, thankfully i made a backup yesterday with the posts, users and and similiar, I only miss (as I see so far ) vb3_words, vb3_postindex . I'm taking nexialys advice now and install a new forum in a testing location to see the correct database table parameters. And see if there are other things missing.

Does anyone know how to rebuild the vb3_words archive btw? I dont have a backup of that or the postindex table :-/
Reply With Quote
  #8  
Old 07-20-2004, 10:44 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ACP / Import & Maintenance / Update Counters / Rebuild Search Index

But this might take several hours, maybe even days depending on the size of your forum.
Reply With Quote
  #9  
Old 07-20-2004, 10:57 PM
jcr jcr is offline
 
Join Date: Apr 2004
Posts: 105
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by KirbyDE
ACP / Import & Maintenance / Update Counters / Rebuild Search Index

But this might take several hours, maybe even days depending on the size of your forum.
Okay! So far so good! ( see my signature ), I believe everything should work once again. Now I just have to stand straight when the wolves return :-S
Reply With Quote
  #10  
Old 07-20-2004, 11:01 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I can't read anything in your forum ... but this might be just because I don't speak norwegian
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 12:25 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04049 seconds
  • Memory Usage 2,246KB
  • Queries Executed 11 (?)
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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (9)postbit_onlinestatus
  • (10)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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete