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
    motochick
    Senior Member

  • motochick
    replied
    Thank you!

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    You need to edit the config.php file on the new server with the new database info.

    Leave a comment:

  • motochick
    Senior Member

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

    Leave a comment:

  • motochick
    Senior Member

  • motochick
    replied
    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!

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    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.

    Leave a comment:

  • motochick
    Senior Member

  • motochick
    replied
    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

    Leave a comment:

  • encryption
    Senior Member

  • encryption
    replied
    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)

    Leave a comment:

  • motochick
    Senior Member

  • motochick
    replied
    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!

    Leave a comment:

  • encryption
    Senior Member

  • encryption
    replied
    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.

    Leave a comment:

  • ampersand
    Senior Member

  • ampersand
    replied
    Thanks

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    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

    Leave a comment:

  • ampersand
    Senior Member

  • ampersand
    replied
    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

    Leave a comment:

  • Zachery
    Former vBulletin Support

  • Zachery
    replied
    That command needs to be run using the SSH command line, not phpmyadmin.

    Leave a comment:

  • ampersand
    Senior Member

  • ampersand
    replied
    using phpmyadmin :P

    Well, now I'm doing it again but this time I split the table into smaller pieces

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    How was the backup made? The most likely cause is an incomplete backup.

    Leave a comment:

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