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

[motochick]

Thank you!

[Steve Machol]

You need to edit the config.php file on the new server with the new database info.

[motochick]

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

[motochick]

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!

[Steve Machol]

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.

[motochick]

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

[encryption]

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)

[motochick]

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!

[encryption]

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.

[ampersand]

Thanks

[Steve Machol]

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/maintenance_ssh_backup

Restore:

http://www.vbulletin.com/docs/html/maintenance_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/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:

http://www.ozerov.de/bigdump.php

[ampersand]

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

[Zachery]

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

[ampersand]

using phpmyadmin :P

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

[Steve Machol]

How was the backup made? The most likely cause is an incomplete backup.