Problem after Server Move

[kinkarso]

Hi guys,

Do you know why my vBulletin forum displays a 'Database error' message after I moved my server? I actually did a full cpanel move twice just to make sure everything was transferred. Everything was, but the error page is still there. Any ideas?

Thank you,
Donny

PS, url is here: http://www.christianavenue.org/forums/

[WEBDosser]

have you created a new database for VB on the new server with the same user/pass and imported the sql ?.

[SEOvB]

Make sure you've uploaded the old database into the new server,

create the mysql user with the same username and password and try again

[snakes1100]

Your db import was incomplete and is missing tables.

You need to backup your db from the old server thru ssh and use mysqldump to dump the db, backing up with cpanel isnt the best choice and it seems it failed this time to re-import your db on the new server.

[kinkarso]

Working now. Apparently, it was missing the 'user' table. Thanks!

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