How do I upload a database to VB?

[PWO81]

Hello, I have VB and transferred webhosts. I have set up the new VB boards on the new server but now I would like to upload the old database with the users, post, etc. that I had on the old sever to the new one. Can someone please tell me how to do this? I have the backup file but I dont know where to upload it.

[Dismounted]

The only 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 timeouts 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

P.S. If you don't have shell access, some people have also 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

[PWO81]

Originally Posted by Dismounted

The only 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 timeouts 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

P.S. If you don't have shell access, some people have also 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

Dismounted, I tired that and it upload but now the forums seem messed up. Missing links, missing images and other stuff. But that's ok, the forum only had 18 members and about 150 posts, no big deal to start over fresh. I tried to look for the backup file that I uploaded to delete it but I can't find it. Is there a way I can remove the backup that I installed? Or should I uninstall and then reinstall VB?

[Jacob B]

I think you could just create a new database, upload the backup, and edit your config.php file (/includes/config.php) to point it to the new database. However I could be wrong.