Server to Server Migration

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Exeter
    New Member
    • Mar 2009
    • 24

    [Forum] Server to Server Migration

    I am moving my board from one server hardware to another. Is there any documentation on how to do this?

    Here is what I did:
    1) Backed up live server DB (4.0.4)
    2) Restored the DB on new server
    3) copied all files to new server
    4) updated config.php to point at new DB

    Now I am getting an unknown DB error. What am I missing

    Thanks
  • Exeter
    New Member
    • Mar 2009
    • 24

    #2
    Can anyone help me with this issue?
    I am havving a real hard time finding this topic in the offical documentation.

    Comment

    • Exeter
      New Member
      • Mar 2009
      • 24

      #3
      Here is the DB error I am getting.

      <!--
      Database error in vBulletin 3.8.4:

      Invalid SQL:

      SELECT styleid, dateline, title
      FROM h_style
      WHERE styleid = 2
      ORDER BY styleid ASC
      LIMIT 1;

      MySQL Error : Unknown column 'dateline' in 'field list'
      Error Number : 1054
      Request Date : Saturday, July 3rd 2010 @ 01:53:53 PM
      Error Date : Saturday, July 3rd 2010 @ 01:53:54 PM
      Script : http://localhost/admincp/index.php
      Referrer :
      IP Address : ::1
      Username :
      Classname : vB_Database
      MySQL Version :
      -->

      Comment

      • anthonyparsons
        Senior Member
        • Mar 2005
        • 2597

        #4
        You need to consult your host, as that is hosting aspects, not forum software discussion.

        Comment

        • Exeter
          New Member
          • Mar 2009
          • 24

          #5
          Pardon me, I run this on my local machine under my own IIS

          I fail to see how you can conclude that this is a hosting issue from just readin the error. Can you please explain what could be wrong with my hosting environment? thanks

          Comment

          • DieselTruck
            Senior Member
            • Feb 2008
            • 131
            • 4.0.x

            #6
            Are you dumping the same database version of the files that you uploaded. You have a 4.0.4 DB you say, but the error is a 3.X series version.

            Comment

            • anthonyparsons
              Senior Member
              • Mar 2005
              • 2597

              #7
              Sorry, but you didn't say a localhost. That kind off makes it worse though. Its environment (server), not software.

              Correcting the DB version via upgrade will likely fix the issues, as you possibly have vb4 files with a 3.x DB still, hence the incompatibilities with tables.

              Comment

              • Exeter
                New Member
                • Mar 2009
                • 24

                #8
                As I said I copied the DB and the files from the server. Everything is 4.0.4.
                I can watch the error get thrown from a 4.0.4 file under the debugger. admincp\global.php line 64

                The remote DB does indeed not have the dateline field. I am trying to debug why it works on the server. U have 4.0.4 files there too.

                An upgrade will probably work, but I'll sign up to repave my forum and CMS.

                Comment

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