Server switch

[Sharkyman]

HELP!!

Done this before with no problem (it was from phpbb to vulletin using that impex tool). Really struggling to do it switching vbul from one server to another (both on vbul 4).

Tell me what I am doing wrong, please.

Installed Vbulletin on the new server (same version).
Grabbed the database from the old one onto my laptop using myphpadmin's export function.
Cleared all the tables on the new database and tried to upload the old database from my lappy using myphpadmin's import function.
Keep getting loads of error massages and it stops. Things like that a column is in correct etc.

Any ideas? Sure I didn't have this problem before when switching from phpbb to vbul.

Help!!

[calorie]

Are the version of MySQL the same on both servers? What did you select for SQL compatibility mode (http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html)? Is there a problem with the database backup (corrupted, incomplete)?

http://www.vbulletin.com/docs/html/moving_servers_backup
http://www.vbulletin.com/docs/html/moving_servers

[Sharkyman]

Hmmm...new (myphpadmin) is 3.2.4

Old is...2.9.2

Is that a massive problem?

--------------- Added 1292264791 at 1292264791 ---------------

Thing is the database is quite large (600mb) so I had to split it up using sql splitter. Some of them upload fine, most come back with an error about columns being in the wrong place.

[calorie]

If you have access to telnet/SSH, I'd try using that to backup/restore. If not, try taking backups of the larger tables using the check boxes instead of relying on the splitter.