Database Backup - Help Needed Please!

[Thomas2485]

Hiya,

We're running Vbulletin on a server together with many other scripts which use our database. I want to empty our database of all tables that are NOT part of the standard Vbulletin package. In essence, I want to clean out our server, re-install Vbulletin, then import all the data (members/posts/threads, etc).

My question is: in the AdminCP, when I try to do a backup, it gives me ALL the tables in our database. I would just like the tables that are used by Vbulletin. I use no prefix. Which tables should I back up?

~Tom

[Zachery]

Im not quite following you,

How will you be importing said data? via na importer or by restoring the database over the newly installed vB ?

[Thomas2485]

The second.

[Floris]

You can not import a .sql dump into an existing NEW installation of vbulletin. This will cause issues.

In order to restore a backup, please read the manual for more details.
(Appendix 3: Technical Documents)

If you want to import into vbulletin, use the impex import system.

[Thomas2485]

Thanks. Then let me rephrase. Suppose I wanted to delete EVERY table we have except Vbulletin3 tables. How would I find out which tables are used by VB3?

[Steve Machol]

Here's the default vB3 tables:

access
adminhelp
administrator
adminlog
adminutil
announcement
attachment
attachmenttype
attachmentviews
avatar
bbcode
calendar
calendarcustomfield
calendarmoderator
calendarpermission
cron
cronlog
customavatar
customprofilepic
datastore
deletionlog
editlog
event
faq
forum
forumpermission
holiday
icon
imagecategory
imagecategorypermission
language
mailqueue
moderation
moderator
moderatorlog
passwordhistory
phrase
phrasetype
pm
pmreceipt
pmtext
poll
pollvote
post
post_parsed
posthash
profilefield
ranks
regimage
reminder
reputation
reputationlevel
search
searchindex
session
setting
settinggroup
smilie
stats
strikes
style
subscribeevent
subscribeforum
subscribethread
subscription
subscriptionlog
template
thread
threadrate
threadviews
upgradelog
user
useractivation
userban
userfield
usergroup
usergroupleader
usergrouprequest
usernote
userpromotion
usertextfield
usertitle
word