The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
|||||||
|
#1
08-12-2005, 10:58 AM
|
|||
|
|||
From 3.0.7 To 3.5 - Whats With My Database?
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? Code:
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 
|
|
#2
08-12-2005, 11:47 AM
|
|||
|
|||
|
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
|
|
#4
08-12-2005, 12:31 PM
|
|||
|
|||
|
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 !?
|
|
#5
08-12-2005, 02:00 PM
|
|||
|
|||
|
Quote:
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.
|
|
#6
08-14-2005, 10:43 AM
|
|||
|
|||
|
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.
|
|
#7
08-14-2005, 01:01 PM
|
|||
|
|||
|
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
|
 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:51 AM.