Migration Issues

[Daggerzz]

I recently transferred my vbulletin board from one server to another. When I did this i just used a ftp program to copy the whole forum directory to my computer and back to the new server. I did the same with the database.
The problem is I have been having two issues.
1. I get database errors stating that certain tables in the database do not exist. This is true they do not exist but they do not exist on my old server either so it is looking for a database table that was never used before. This makes no sense to me.

2. I get errors like this from time to time: Fatal error: Call to undefined function fetch_standard_deviated_levels() in /forum/includes/functions_search.php on line 1043

Does anybody have any clue as to what is going on. Ive tried to re upload the files like functions_search.php thinking that maybe there was a problem with upload but it still does not help.

[glennybee]

Are PHP and MySQL up-to-date on the new server?

[Dismounted]

Did you get these errors on the old server?

[Marco van Herwaarden]

How did you move the database?

[Daggerzz]

Sorry for the delay

I had no errors on the old server.

I think the php/mysql are up to date.

I transfered the DB by using phpMyAdmin and compressing the DB into about 6 files then downloading them to my computer and uploading them to the new server.

[Marco van Herwaarden]

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