Okay, so I'm setting up a new install to transfer my old site which includes users and posts. Setting up the new site with styles, email settings and options, working out bugs and tuning the server - now that it's all setup I want to transfer users and posts - is there a method to do this without over writing all the software setting? That is, how can I import the posts and users without altering all the other settings?
Update / Import
Collapse
X
-
Tags: None
-
By using ImpEx; you can download it for free in your Member's Area.
More information can be found here: http://www.vbulletin.com/docs/html/impex_planningCongratulations on the death of vBulletin, Internet Brands.
-
Is there a faster method for purging existing forum / posts other than dropping it via admincp? I have many sections, each with first test import posts - it seems to take a bit of time to drop each section.- lhComment
-
Nope, that's the safest way to do this without messing up the database.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
It's literately taking hours. I plan on making a backup of the forum sans all sections / posts so I can, if I need to, restore it to an empty state .. wish I'd thought of that before the first import.- lhComment
-
Purged all, still data remaining.
Once I managed to purge ALL threads, all posts, all users except my admin; purge everything I could find an option to purge I found that birthdays were still being displayed on FORUMHOME; researching this I noticed data tables with values I didn't expect. These are the onces that caught my eye, and for which I could find no method of emptying.
Code:Table Data Length Index Length Overhead attachment 4.31 MB 11.0 KB 4.31 MB mailqueue 80.8 KB 2.0 KB 80.8 KB moderatorlog 1.35 MB 698.0 KB 0 pm 1.52 MB 3.10 MB 1.52 MB pmreceipt 2.37 MB 1.52 MB 2.37 MB pmtext 41.86 MB 1.94 MB 41.85 MB poll 293.7 KB 28.0 KB 290.6 KB pollvote 809.3 KB 1.02 MB 809.3 KB post 919.15 MB 565.22 MB 919.15 MB reputation 2.33 MB 3.09 MB 2.33 MB thread 34.69 MB 30.77 MB 34.69 MB threadrate 29.8 KB 27.0 KB 29.8 KB user 9.95 MB 2.96 MB 9.95 MB usertextfield 1.36 MB 712.0 KB 1.36 MB
Code:Table Data Length Index Length Overhead access 324 Bytes 2.0 KB 324 Bytes addon 180 Bytes 2.0 KB 0 adminhelp 70.0 KB 44.0 KB 0 administrator 120 Bytes 2.0 KB 20 Bytes adminlog 1.06 MB 304.0 KB 0 adminmessage 160 Bytes 5.0 KB 0 adminutil 327.6 KB 2.0 KB 327.6 KB announcement 7.2 KB 4.0 KB 0 announcementread 0 1.0 KB 0 attachment 4.31 MB 11.0 KB 4.31 MB attachmentpermission 0 1.0 KB 0 attachmenttype 724 Bytes 3.0 KB 0 attachmentviews 0 1.0 KB 0 avatar 0 1.0 KB 0 bbcode 192 Bytes 3.0 KB 0 calendar 116 Bytes 3.0 KB 0 calendarcustomfield 0 1.0 KB 0 calendarmoderator 0 1.0 KB 0 calendarpermission 150 Bytes 4.0 KB 0 cron 1.5 KB 4.0 KB 0 cronlog 945.8 KB 82.0 KB 0 customavatar 0 1.0 KB 0 customprofilepic 0 1.0 KB 0 datastore 86.2 KB 2.0 KB 31.3 KB deletionlog 37.6 KB 27.0 KB 37.6 KB downloads 0 1.0 KB 0 editlog 1.77 MB 842.0 KB 1.77 MB event 40.6 KB 15.0 KB 35.5 KB externalcache 75.1 KB 4.0 KB 75.1 KB faq 1.4 KB 4.0 KB 0 forum 10.0 KB 2.0 KB 10.0 KB forumpermission 132 Bytes 3.0 KB 132 Bytes forumread 0 1.0 KB 0 holiday 0 1.0 KB 0 icon 2.8 KB 2.0 KB 0 imagecategory 84 Bytes 2.0 KB 0 imagecategorypermission 0 1.0 KB 0 impexerror 0 1.0 KB 0 infraction 44 Bytes 7.0 KB 0 infractionban 0 1.0 KB 0 infractiongroup 0 1.0 KB 0 infractionlevel 72 Bytes 2.0 KB 0 language 317.9 KB 2.0 KB 0 links_categories 0 1.0 KB 0 links_editorials 0 1.0 KB 0 links_links 0 1.0 KB 0 links_modrequest 0 1.0 KB 0 links_newlink 0 1.0 KB 0 links_subcategories 0 1.0 KB 0 links_votedata 0 1.0 KB 0 mailqueue 80.8 KB 2.0 KB 80.8 KB menu 496 Bytes 2.0 KB 0 moderation 9.5 KB 21.0 KB 9.5 KB moderator 338 Bytes 3.0 KB 325 Bytes moderatorlog 1.35 MB 698.0 KB 0 nntp_groups 88 Bytes 4.0 KB 0 nntp_settings 4.7 KB 4.0 KB 0 passwordhistory 56.0 KB 15.0 KB 0 paymentapi 2.0 KB 2.0 KB 0 paymentinfo 0 1.0 KB 0 paymenttransaction 0 1.0 KB 0 phrase 1.33 MB 497.0 KB 0 phrasetype 2.0 KB 2.0 KB 0 plugin 952 Bytes 3.0 KB 0 pm 1.52 MB 3.10 MB 1.52 MB pmreceipt 2.37 MB 1.52 MB 2.37 MB pmtext 41.86 MB 1.94 MB 41.85 MB podcast 0 1.0 KB 0 podcastitem 0 1.0 KB 0 poll 293.7 KB 28.0 KB 290.6 KB pollvote 809.3 KB 1.02 MB 809.3 KB post 919.15 MB 565.22 MB 919.15 MB posthash 98 Bytes 3.0 KB 98 Bytes postindex 0 1.0 KB 0 postparsed 0 1.0 KB 0 product 200 Bytes 2.0 KB 0 productcode 0 1.0 KB 0 productdependency 44 Bytes 2.0 KB 0 profilefield 96 Bytes 3.0 KB 0 profilefieldcategory 0 1.0 KB 0 ranks 0 1.0 KB 0 regimage 270 Bytes 2.0 KB 270 Bytes reminder 0 1.0 KB 0 reputation 2.33 MB 3.09 MB 2.33 MB reputationlevel 135 Bytes 3.0 KB 0 rssfeed 0 1.0 KB 0 rsslog 0 1.0 KB 0 search 77.7 KB 18.0 KB 77.7 KB setting 32.6 KB 9.0 KB 0 settinggroup 1.2 KB 2.0 KB 0 sigparsed 0 1.0 KB 0 sigpic 0 1.0 KB 0 smilie 4.0 KB 2.0 KB 0 stats 49.6 KB 32.0 KB 0 strikes 48 Bytes 3.0 KB 48 Bytes style 74.0 KB 2.0 KB 0 subscribeevent 0 1.0 KB 0 subscribeforum 19.0 KB 40.0 KB 19.0 KB subscribethread 7.34 MB 15.03 MB 7.34 MB subscription 0 1.0 KB 0 subscriptionlog 0 1.0 KB 0 subscriptionpermission 0 1.0 KB 0 tachyforumpost 0 1.0 KB 0 tachythreadpost 0 1.0 KB 0 template 2.52 MB 30.0 KB 734.4 KB templatehistory 0 1.0 KB 0 thread 34.69 MB 30.77 MB 34.69 MB threadrate 29.8 KB 27.0 KB 29.8 KB threadread 0 1.0 KB 0 threadredirect 0 1.0 KB 0 threadviews 0 1.0 KB 0 topics 224 Bytes 2.0 KB 0 upgradelog 51.8 KB 10.0 KB 0 user 9.95 MB 2.96 MB 9.95 MB useractivation 5.0 KB 9.0 KB 5.0 KB userban 2.5 KB 3.0 KB 2.5 KB userfield 1.70 MB 833.0 KB 1.70 MB usergroup 8.7 KB 3.0 KB 0 usergroupleader 0 1.0 KB 0 usergrouprequest 0 1.0 KB 0 userlist 0 1.0 KB 0 usernote 0 1.0 KB 0 userpromotion 29 Bytes 3.0 KB 0 usertextfield 1.36 MB 712.0 KB 1.36 MB usertitle 1.0 KB 2.0 KB 0 vbfields 28.2 KB 1.0 KB 0 word 0 1.0 KB 0
- lhComment
-
If you want to 'purge' everything, why not just reinstall fresh?
Birthdays are cached and are updated once a day.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
The reason *was* because I had already setup the new board including modifications and add-ons, as well as imported a test copy of my live data to test server tuning -- was trying to stage it so all I had to do was import the database from my live site in a single night. It appears this is not something vB is currently capable of doing well, so this time, I guess, I will start all over from scratch, then before doing a dry run import, I will copy the fresh [posts empty] db before the import, that way I can simply overwrite the test db before I do the live import.- lhComment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment