From 3.0.7 To 3.5 - Whats With My Database?

[Wordplay]

i'm about to upgrade to 3.5 but what should i do with my database?

now i've got alot of hacks installed on my vb 3.0.7, what i'd like to know is. should i delete some database tables? now my 3.5 wont have any hacks installed from the start, and the hacks that come later on are all supposed to start a-new without old database tables. so can i just delete the tables i dont need and then back up the entire database and import it to my new server with 3.5 installed? if so what tables can i get rid of? or what tables do i need to keep?

4images_categories
4images_comments
4images_groupaccess
4images_groupmatch
4images_groups
4images_images
4images_images_temp
4images_lightboxes
4images_postcards
4images_sessions
4images_sessionvars
4images_settings
4images_users
4images_wordlist
4images_wordmatch
access
adminhelp
administrator
adminlog
adminutil
adv_modules
adv_pages
adv_setting
adv_settinggroup
announcement
attachment
attachmenttype
attachmentviews
avatar
banners
battlesys_battles
battlesys_favlines
battlesystem
bbcode
calendar
calendarcustomfield
calendarmoderator
calendarpermission
cpsession
cron
cronlog
customavatar
customprofilepic
datastore
deletionlog
editlog
event
faq
favourites
forum
forumpermission
game_rate
gamechallenges
gamenews
games
gamesessions
gifts
his_installed
holiday
icon
imagecategory
imagecategorypermission
journal_comments
journal_entries
journal_moods
journal_settings
journals
language
mailqueue
moderation
moderator
moderatorlog
passwordhistory
petz_adopt
petz_arena
petz_bank
petz_battle
petz_default
petz_inventory
petz_items
petz_logs
petz_petz
petz_settings
petz_shops
petz_store
phrase
phrasetype
pm
pmreceipt
pmtext
poll
pollvote
post
post_parsed
posthash
postindex
profilefield
ranks
regimage
reminder
reputation
reputationlevel
search
session
setting
settinggroup
shoutbox_posts
smilie
statistik_browser_os
statistik_domain
statistik_einstellungen
statistik_laender
statistik_log
statistik_referer
statistik_spider
statistik_zaehler
stats
strikes
style
subscribeevent
subscribeforum
subscribethread
subscription
subscriptionlog
teamchat
teamjoin
teampolls
teams
template
thread
threadrate
threadviews
upgradelog
user
user_guestbook
user_webpage
useractivation
userban
userfield
usergroup
usergroupleader
usergrouprequest
usernote
userpromotion
usertextfield
usertitle
utt_store_action
utt_store_asvs
utt_store_bank
utt_store_history
vb_jukebox_trax
vbookie_bets_placed
vbookie_groups
vbookie_item_options
vbookie_items
vbookie_news
word

[Marco van Herwaarden]

I suggest you first use ImpEx (downloadable from the members area, make sure read the stickied topics about it in the Import System forum at vb.com) to create a fresh clean 307 database. Then migrate to 3.5

[Wordplay]

they've got a software that cleans the database? wow... stunning... i hope that works on mine.

[MarcoH64 just made my day]

[nexialys]

best is to BACKUP your actual production site, and make a BACKUP safe...

now you COPY your actual site on a different location and test the ImpEx with the backup, not your production site... or you may loose everything by error!

did i mention BACKUP !?

[jugo]

they've got a software that cleans the database? wow... stunning... i hope that works on mine.

[MarcoH64 just made my day]


It's not a DB Cleaner. Essentially what you are doing is installing another instance of vB and importing you users, posts and threads, etc into it. This creates a clean DB because IMPEX will not import any DB modifications made by hacks.

[Wordplay]

i was running a vb 3.0.x with a whole lot of hacks on it. i now updated that board to 3.5, now i want to transfer my board to a completely new domain, i've already uploaded all the files neccessary (from the 3.5 rc2 release) onto my new domain. all i really wish to do is import the neccessary database tables. since i have so many hacks running (arcade/journal/image gallery) which i all wish to get rid of entirely, i just need the database tables from vbulletin (posts, threads, avatars, userinfo, members, etc).

my question, as i cannot get impex to work at ALL. is whether i could just export the neccessary fields manually and import them into my new board. or whether i really should use impex.

OPTION 1> if i dont use impex, which are the database tables i will need to export and then import into the new database on a different server in order to keep all i need? that being everything vbulletin usually caches without any hacks or such?

OPTION 2> if i should use impex, how do i get it to work? my current conflict is the following... i uploaded impex to the forum directory. now in my vbulletin admin cp, all i see is maintainance, and no import & maintainance... so i cant use it. and if i go to the .../impex/index.php file directly i get a database error.

somebody please help out.

[Marco van Herwaarden]

Option 1 <-- save yourself a lot of downtime and headaches, and don't even try this unless you are an advanced expert.

Option 2 <-- AFAIK There is no ImpEx for 3.5 yet, it will become available after 3.5 goes gold. Like i said before, use ImpEx on your 3.0 board, then upgrade to 3.5