View Single Post
  #4  
Old 10-03-2006, 02:22 PM
Brandr Brandr is offline
 
Join Date: Aug 2006
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Greetings,

Are there any threads which comprehensively explain how to restore a back-up forum sql database file to the server?

I recently had to ask a vBulletin technician to get my Forum up and running, because after i uploaded the backed-up data base successfully, I was still getting a database error message in the browser.

It would be helpful if there was a step by step guide to restoring an sql back-up file so that vBulletin licensees like myself who are not master technicians can restore our forum database' without having to impose on other more savvy licensees or the vBulletin staff, which I find embarrassing.

This is what I did:

I uploaded the sql file (Only 12M's) to a new database ( via phpMyAdmin ) which i gave the same name as the previous, deleted one.
The config.php file had the corresponding database name, username, and password.

When I tried to log into my forum, I received a database error message.

What steps did i miss in the process of restoring a backed-up database so that the forum will operate as previously?

I found a more recent back-up file that would pretty much restore all of my forum's posts that were present before our disaster, I would like to use it but I'm scared to death of tampering with the database after a generous tech so recently restored it.

This is the only issue that I cannot seem to master as a new VBulletin Administrator.
Is there a (comprehensive) guide to sql back-up file restoration already present on vBulletin.org/com? ( If so, I can't find it)
If not, I Implore someone to create It.

Best wishes,
_B.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01115 seconds
  • Memory Usage 1,762KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (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_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete