Announcement

Collapse
No announcement yet.

I switched servers but now I can't get my vBulletin to work

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

  • #16
    I know that, but it still stopped somehow, but it might be phpmyadmin that dont make good enough backups when the table size is that big I dont know

    Comment


    • #17
      The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

      Please see the instructions here:

      Backup:
      http://www.vbulletin.com/docs/html/m...nce_ssh_backup

      Restore:
      http://www.vbulletin.com/docs/html/m...ce_ssh_restore

      If you don't have telnet or SSH access, some people have reported success with these scripts:

      MySQLDumper:
      http://www.mysqldumper.de/en/index.php

      MySQLHotxcopy:
      http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

      Bigdump:
      http://www.ozerov.de/bigdump.php
      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


      • #18
        Thanks

        Comment


        • #19
          Originally posted by ampersand View Post
          Im moving to a dedicated server as we speak, but I have a problem even when using SSH. I have made a database dump of my vBulletin database and uploaded it to root using ftp. I login with SSH and start importing the database, but on table vb3_post it always stops after 605 000 records when there are a total of 850 000 something..

          What can I do now to make this work ?

          I'm using this command
          Yes I've had that error on all my backups until one of my admins did a test on one of the dbs and figured that is exactly where phpmyadmin was stalling on the backups. a years worth of backups are useless now.

          Use mysqldumper, its more thorough.
          www.MJWebhosting.com - (Vbulletin Forum Hosting)
          www.MercuryServer.com - (Our vBulletin forum Managed & hosted by MJWebhosting)

          Comment


          • #20
            HEAD SPINNING!

            PART 1
            Did the sqldump for both my forums using
            mysqldump --opt -Q -h localhost -u dbXXXXXX -p dbXXXXXXXX >smj.backup011007b.sql

            Seemed to work. They show up on ftp but even though the forums are about the same size, one is 1.5GB and the other came up at only 217MB! Something is wrong with that second one. Not sure what the heck is wrong. Use the same command, just typed in the different database name. Any ideas?

            PART 2
            Need to move to new server which is how I found this thread (looking for instructions) So, are you saying that using the instructions at the beginning of this thread that all I need to do to move servers is upload the mysqldump backup to the new server (once I get the backup working right)? Don't I need to install vbulletin software on the new server or is that part of the backup.

            Thank you!

            Comment


            • #21
              Originally posted by motochick View Post
              Don't I need to install vbulletin software on the new server or is that part of the backup.

              Thank you!
              You only need to "install" vbulletin when you are starting afresh. If you restore your DB ok, all you need to do is upload your forums dir from your old server to the new server and you should be good to go (as long as all the connection variables are the same)
              www.MJWebhosting.com - (Vbulletin Forum Hosting)
              www.MercuryServer.com - (Our vBulletin forum Managed & hosted by MJWebhosting)

              Comment


              • #22
                thanks encryption, The VB manuals instructions are pretty good for doing that restore. Hopefully I do it correctly when I get to that section.

                Right now I am following the instructions from the VB manual on how to backup/move to a new server. Section 2 - Transferring to the new server.... Does this mean it is removing it from the old server and moving it to the new server OR does it mean it is COPYING it from the old server to the new server.

                Sorry for such a basic question but I don't want to mess anything up.

                Oh, and the instructions I am referring to are at http://www.vbulletin.com/docs/html/moving_servers

                Comment


                • #23
                  It means you make a backup of the database (not remove the original) copy that backup file to the new server, then restore this to a new database on that server.
                  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


                  • #24
                    Thanks Steve, I guess I really knew that but I just wanted to completely sure.

                    ok, so I have one more thing before I Get R Dun
                    Step 4 in the instructions says to open the includes/config.php file...... does this mean that at that point my forum will be on the new server, I go to the forums admin control panel to find that includes file and change it there?

                    or does it mean that I would FTP that file from the server to my computer, edit it and upload it back to the server? AHHHHH!

                    Thank you!

                    Comment


                    • #25
                      It is in the FTP. That is where I do it right? Yeah, getting close!

                      Comment


                      • #26
                        You need to edit the config.php file on the new server with the new database info.
                        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


                        • #27
                          Thank you!

                          Comment

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