Update / Import

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lee Herron
    Member
    • Jun 2001
    • 85

    Update / Import

    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?
    - lh
  • Onimua
    Senior Member
    • Apr 2005
    • 4572

    #2
    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_planning
    Congratulations on the death of vBulletin, Internet Brands.

    Comment

    • Lee Herron
      Member
      • Jun 2001
      • 85

      #3
      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.
      - lh

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        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

        • Lee Herron
          Member
          • Jun 2001
          • 85

          #5
          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.
          - lh

          Comment

          • Lee Herron
            Member
            • Jun 2001
            • 85

            #6
            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
            Here are the values of all the tables in the database:
            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
            Any ideas on how I may complete the job of purging unneeded left over data?
            - lh

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #7
              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

              • Lee Herron
                Member
                • Jun 2001
                • 85

                #8
                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.
                - lh

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...