Announcement

Collapse
No announcement yet.

Server to Server Migration

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [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

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

    Comment


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


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

        Comment


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


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


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


              • #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...
                X