Server to Server Migration

[Exeter]

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.

[Marco van Herwaarden]

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

[Exeter]

<!--
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 :
-->

[profanitytalker]

Have you tried repairing your db?

[Exeter]

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.

[Marco van Herwaarden]

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

Was the restore successful without any warnings?

[Exeter]

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

[Marco van Herwaarden]

Documentation on server is move is at: Moving Servers

[Exeter]

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

[Marco van Herwaarden]

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.