Moving Database to a new Server

[tlev]

Hi, I need to move my vB3 database to a new server as I have switched hosting companies. My new company said to do the following:

a) create a dump of the database on your old server
b) transfer the dump file from the old server into your new account
c) create a database via your panel
d) let us know where the dump file is located and give us the dbname what we
need to restore

I need to know how to 'create a dump' using myphpadmin. Can anyone give some step by step instructions? Thanks

[Josh Combs]

you should check this out http://www.vbulletin.com/docs/html/main/moving_servers

[Steve Machol]

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

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

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.

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

[1yesfan]

thanks folks.

[Mr_Butter]

An excellent ssh client is putty.

You can get it for free here:

http://www.chiark.greenend.org.uk/~sgtatham/putty/