vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Essential tables for database transfer (https://vborg.vbsupport.ru/showthread.php?t=127083)

Timelord 09-20-2006 02:37 AM
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! :)

Paul M 09-20-2006 02:52 AM
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.

Timelord 09-20-2006 03:00 AM
Thank you for your response. I will go through and see if any extra tables have been created and not transfer those.


All times are GMT. The time now is 07:13 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.00924 seconds
  • Memory Usage 1,717KB
  • 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)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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