PDA

View Full Version : Help with Migrating Database


Blacura
06-30-2009, 02:57 AM
ohh lord i am having a hell of a time getting help on this problem. i have backed up my database but i cant seem to get it back up and running on my new server. all members gone all posts gone. please someone out of the kindness of their heart help me!!!!!

Dismounted
06-30-2009, 04:34 AM
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/maintenance_ssh_backup

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

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