No announcement yet.

Server to Server Migration

  • 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


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


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


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


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


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


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


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


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