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 09-20-2006, 02:37 AM
Timelord Timelord is offline
 
Join Date: May 2004
Location: Maryland, USA
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Essential tables for database transfer

Hello everyone,

I have just bought a brand new server which I will be using to run my web site on from now on. I want to transfer my current database from my current forum to the new server, but I'm kind of looking forward to a sort of "fresh start" (my current vB has some remnants of partially installed mods and just generic stuff that I'd like to leave behind as much as possible) and so I don't want everything to be transferred. Can someone tell me what tables are essential for me to transfer over? I need users, forums, and posts, mainly, but there might be something else obvious that I should transfer but I'm not thinking of.

Here is my current complete list of tables in my database:
Code:
access
adminhelp
administrator
adminlog
adminmessage
adminutil
announcement
announcementread
attachment
attachmentpermission
attachmenttype
attachmentviews
avatar
bbcode
calendar
calendarcustomfield
calendarmoderator
calendarpermission
cpsession
cron
cronlog
customavatar
customprofilepic
datastore
deletionlog
editlog
event
externalcache
faq
forum
forumpermission
forumread
holiday
icon
imagecategory
imagecategorypermission
infraction
infractionban
infractiongroup
infractionlevel
language
mailqueue
moderation
moderator
moderatorlog
passwordhistory
paymentapi
paymentinfo
paymenttransaction
phrase
phrasetype
plugin
pm
pmreceipt
pmtext
podcast
podcastitem
poll
pollvote
post
posthash
postindex
postparsed
product
productcode
productdependency
profilefield
ranks
regimage
reminder
reputation
reputationlevel
rssfeed
rsslog
search
session
setting
settinggroup
sigparsed
sigpic
smilie
stats
strikes
style
subscribeevent
subscribeforum
subscribethread
subscription
subscriptionlog
subscriptionpermission
tachyforumpost
tachythreadpost
template
templatehistory
thread
threadrate
threadread
threadredirect
threadviews
upgradelog
user
useractivation
userban
userfield
usergroup
usergroupleader
usergrouprequest
usernote
userpromotion
usertextfield
usertitle
vbfields
word
Thanks very much for any assistance offered!
Reply With Quote
  #2  
Old 09-20-2006, 02:52 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In the install folder you will find an SQL Schema file - that shows all the tables used by vb. I suggest you transfer them all.
Reply With Quote
  #3  
Old 09-20-2006, 03:00 AM
Timelord Timelord is offline
 
Join Date: May 2004
Location: Maryland, USA
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you for your response. I will go through and see if any extra tables have been created and not transfer those.
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:52 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.08090 seconds
  • Memory Usage 2,175KB
  • 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
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete