Import Data from one vB 3.5 system to another

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lou Jacob
    New Member
    • Oct 2005
    • 8

    Import Data from one vB 3.5 system to another

    Hello -

    We will be migrating our production forum to a new server in several weeks. We are running vB 3.5 in production now, and I am setting up a new version on our new system (also vB 3.5) and I am installing new templates, plug-ins, etc.

    I would like to be able to import the forums and posts from the production system onto the development system as the last step, before cutting over to the new server.

    The only way I've been able to "export and import" from the production to the dev server is using a full mysql dump and restore; but that overwrites too many important things on the new server.

    I've looked into the Impex system but it only had the ability to export from 3.0 and import into 3.5 - not 3.5 to 3.5.

    Am I missing something here? Is there a [relatively] easy way to do this? I am not a mysql expert, but I have figured out the basic dump/restore syntax - do I need to selectively dump/restore certain tables and if so, which ones (and how?)

    Your help is appreciated!

    Lou

    ptvupgrade.com is your first and best source for all of the information you’re looking for. From general topics to more of what you would expect to find here, ptvupgrade.com has it all. We hope you find what you are searching for!
    Last edited by Lou Jacob; Thu 27 Oct '05, 7:54pm.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    The latest version of Impex does support 3.5-to-3.5 imports.
    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

    • Lou Jacob
      New Member
      • Oct 2005
      • 8

      #3
      Originally posted by Steve Machol
      The latest version of Impex does support 3.5-to-3.5 imports.
      Hey, that is great. I will update and give it a try. Thanks for the follow-up.

      Comment

      • Lou Jacob
        New Member
        • Oct 2005
        • 8

        #4
        Well, I've given it a try but things don't appear as they should. What I have done is the following:

        1) done a full mysql dump of our production database (used with vB 3.5) as follows:

        Code:
        mysqldump --add-drop-table -u vbulletin forum_ptvupgrade_com_-_ptvforum -p > $1
        2) restore into a 'temporary' database on our dev server as follows:

        Code:
        mysql -u vbulletin -p vbulletin-impex < dump_102805.sql
        3) download the most recent IMPEX distribution and configured the "source" database appropriately

        4) as per the instructions, only used the vb3 system directory as I could not find any other that seemed more appropriate

        5) upon execution of IMPEX it is showing up as a 3.0.X database even though it has been upgraded to 3.5?

        I've attempted to step through the import functions, but I get database errors on the "usergroup import" (step three).

        I am attempting to follow the instructions, word for word, and apparently I am missing something...

        Any guidance would be appreciated!

        Thanks,
        Lou
        Attached Files
        Last edited by Lou Jacob; Fri 28 Oct '05, 9:22am.

        Comment

        • Jerry
          Senior Member
          • Dec 2002
          • 9137
          • 1.1.x

          #5
          What is the usergroup error ?
          I wrote ImpEx.

          Blog | Me

          Comment

          • Lou Jacob
            New Member
            • Oct 2005
            • 8

            #6
            ImpEx Database errormysql error: Invalid SQL:
            INSERT INTO usergroup
            (
            importusergroupid, title, description,
            usertitle, passwordexpires, passwordhistory,
            pmquota, pmsendmax, pmforwardmax,
            opentag, closetag, canoverride,
            ispublicgroup, forumpermissions, pmpermissions,
            calendarpermissions, wolpermissions, adminpermissions,
            genericpermissions, genericoptions, attachlimit,
            avatarmaxwidth, avatarmaxheight, avatarmaxsize,
            profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize
            )
            VALUES
            (
            '1',
            'Unregistered / Not Logged In',
            '',
            'Guest',
            '0',
            '0',
            '0',
            '0',
            '',
            '',
            '',
            '0',
            '0',
            '725007',
            '0',
            '49',
            '0',
            '0',
            '50331715',
            '8',
            '0',
            '50',
            '50',
            '20000',
            '100',
            '100',
            '100000'
            )

            mysql error: Unknown column 'pmforwardmax' in 'field list'
            mysql error number: 1054
            Date: Friday 28th of October 2005 10:37:40 AM

            ---------------

            Does that help?

            Thx,
            Lou
            Attached Files

            Comment

            • Jerry
              Senior Member
              • Dec 2002
              • 9137
              • 1.1.x

              #7
              pmforwardmax is a valid column for vBulletin 3.5 in the usergroup table.

              If you don't have that you must have an incomplete database or a broken upgrade ?

              Are you sure your target database is a freshly installed 3.5 ?
              I wrote ImpEx.

              Blog | Me

              Comment

              • Lou Jacob
                New Member
                • Oct 2005
                • 8

                #8
                Originally posted by Jerry
                pmforwardmax is a valid column for vBulletin 3.5 in the usergroup table.

                If you don't have that you must have an incomplete database or a broken upgrade ?

                Are you sure your target database is a freshly installed 3.5 ?
                The "target" is a vbulletin 3.5 install which I then did a mysql restore into prior to attempting Impex. I can do a clean install of vB 3.5 and zap the database, I suppose....

                Comment

                • Lou Jacob
                  New Member
                  • Oct 2005
                  • 8

                  #9
                  That seems to have done the trick. I hope it was my 'manual' import process that messed things up.

                  My only concern at this point is having the ability to set up plugins (like GAB from the vbgeek) on the new site and that I'll just be able to sqldump and use Impex to bring in the latest snapshot of our current production system and then go live with the new site shortly there after. Is that something that should be expected to go relatively smoothly?

                  Thanks again for your responses.

                  Lou

                  Comment

                  • Jerry
                    Senior Member
                    • Dec 2002
                    • 9137
                    • 1.1.x

                    #10
                    As long as you are going to a 3.5 install then yes, thats sounds fine to me.
                    I wrote ImpEx.

                    Blog | Me

                    Comment

                    • Lou Jacob
                      New Member
                      • Oct 2005
                      • 8

                      #11
                      My only other feedback is that unless I missed something, it is necessary to rebuild the index information, forum information, etc after doing a the imports with Impex; it would be good to have that as a reminder on the main Impex screen only because when I was done importing, and I went to the forum, very little was there. It scared me at first and then I started thinking about it and realized I should do that. I'll admit that after finishing the Impex I did not go back to the manual as I was excited about having gotten so far...

                      Anyway, have a great weekend and thanks for the great support.

                      Comment

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