Server to Server Migration
 

I am having trouble moving my forum from one server to another. here is the process:

1) Backup DB using Mysql admin
2) restore DB on new server
3) Copy the files to new webserver directory
4) update config.php to use the new DB location

Now I am getting a DB error without any information when I access the admincp.
Disabling all hooks and using tools.php does not help.

What am I missing?

Thanks

I did not get any help on vbulletin.com.

Right click on the error page and choose show page source. Copy & paste the error message here.

<!--
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT styleid, dateline, title
FROM h_style
WHERE styleid = 2
ORDER BY styleid ASC
LIMIT 1;

MySQL Error : Unknown column 'dateline' in 'field list'
Error Number : 1054
Request Date : Saturday, July 3rd 2010 @ 01:53:53 PM
Error Date : Saturday, July 3rd 2010 @ 01:53:54 PM
Script : http://localhost/admincp/index.php
Referrer :
IP Address : ::1
Username :
Classname : vB_Database
MySQL Version :
-->

Have you tried repairing your db?

Yes, I tried to repair the tables using tools.php; no luck

I still have the forum running on the original server. No problems there.

Did you install the files of the same vBulletin version on the new server/localhost?

Was the restore successful without any warnings?

I copied the files from the live server. I did not do a local install.
Is that required? In my original post I detailed everything I did.

If there is a process for migration, please let me know. I could not find any documentation for this.

Thanks for your help

Documentation on server is move is at: Moving Servers

Thanks, I followed these steps as indicated. No luck.

I also verified that the column 'dateline' is not present on my live server (the source that is working fine), and on a fresh install of VB 4.0.4.

this is getting annoying

Please check if the config.php of the copied installation on your localhost is pointing to the correct database (the restored database) and with the correct table prefix.