Switch Hosts

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Michael_Tree
    Senior Member
    • Aug 2005
    • 113
    • 3.5.x

    Switch Hosts

    How do I switch hosts and keep posts and members on the new server?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Instructions for moving servers are in the online manual here:



    Note: The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

    Backup:


    Restore:


    This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.
    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

    • rnmcd
      Senior Member
      • Aug 2004
      • 1610
      • 3.5.x

      #3
      Originally posted by Michael_Tree
      How do I switch hosts and keep posts and members on the new server?
      How did it work for you? Smoothly?

      I need to do the same thing but my current host doesn't offer shell access.

      Comment

      • Colin F
        Senior Member
        • May 2004
        • 17689

        #4
        I've had mostly good experiences with mysqldumper, which allows you to backup big databases through a php interface without timing out.
        Best Regards
        Colin Frei

        Please don't contact me per PM.

        Comment

        • rnmcd
          Senior Member
          • Aug 2004
          • 1610
          • 3.5.x

          #5
          My present host uses cPanel and that has a feature to backup an entire site (including the DB). If I do that, can I just provide the zipped file to my new host to install?

          That sounds too easy to work

          Comment

          • feldon23
            Senior Member
            • Nov 2001
            • 11291
            • 3.7.x

            #6
            The issue with MySQLAdmin is that you may get a partial database download and not know it. MySQLDumper downloads your database a "bite at a time".

            You can confirm that you have a complete MySQL download of your vBulletin forum by seeing if the last few lines of the file are:

            UNLOCK TABLES;
            /*!40000 ALTER TABLE word ENABLE KEYS */;

            Comment

            • rnmcd
              Senior Member
              • Aug 2004
              • 1610
              • 3.5.x

              #7
              Originally posted by feldon23

              You can confirm that you have a complete MySQL download of your vBulletin forum by seeing if the last few lines of the file are:

              UNLOCK TABLES;
              /*!40000 ALTER TABLE word ENABLE KEYS */;
              What file am I looking for and do I need a special program to read/open the file?

              Comment

              • Colin F
                Senior Member
                • May 2004
                • 17689

                #8
                There's no such thing as 'too easy'
                Last edited by Colin F; Tue 21 Mar '06, 7:09am.
                Best Regards
                Colin Frei

                Please don't contact me per PM.

                Comment

                • feldon23
                  Senior Member
                  • Nov 2001
                  • 11291
                  • 3.7.x

                  #9
                  Originally posted by rnmcd
                  What file am I looking for and do I need a special program to read/open the file?
                  The SQL file you got out of cPanel/MySQLAdmin. You can open it with a text editor but if it is quite large (dozens or hundreds of megabytes), I recommend something like UltraEdit.

                  Comment

                  • rnmcd
                    Senior Member
                    • Aug 2004
                    • 1610
                    • 3.5.x

                    #10
                    Originally posted by feldon23
                    The SQL file you got out of cPanel/MySQLAdmin. You can open it with a text editor but if it is quite large (dozens or hundreds of megabytes), I recommend something like UltraEdit.
                    So I need to download the SQL file from cPanel/MySQLAdmin separately from the full-site backup that I do in cPanel?

                    Comment

                    • feldon23
                      Senior Member
                      • Nov 2001
                      • 11291
                      • 3.7.x

                      #11
                      I don't know what the "full site backup" in cPanel entails. Have you got a website that describes it?

                      Comment

                      • rnmcd
                        Senior Member
                        • Aug 2004
                        • 1610
                        • 3.5.x

                        #12
                        Here's something:

                        Comment

                        • Colin F
                          Senior Member
                          • May 2004
                          • 17689

                          #13
                          The full backup will also backup the mysql database.
                          I've also never had any problems transferring a full cPanel backup.
                          Best Regards
                          Colin Frei

                          Please don't contact me per PM.

                          Comment

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