...*HITS HEAD*

One more question, then.

The orginal db had 44 tables. This new one has 17.

...?!?

I've never used the backup options in cPanel I'm afraid. Does cPanel give any messages/warnings when doing the restore?

No, it doesn't.

I ended up just throwing it over there table by table. I don't suggest anyone do this EVER because it SUCKS when it doesn't work, and you have to copy it all by hand and...gah. [/rant]

Thanks for the help, guys!

Hey bexie,

We had the same problems. Upgraded to vB 3 and then moved to a new server 3 days later. (I don't recommend doing this!)

Issues we had: our old site didn't use cPanel, we were on dialup, and there was a maximum-transfer size limit.

I tried sweet-talking the old host into doing the backup for me, because it failed time and time again. They did, but even with specific instructions, they repeatedly performed it all in .myd.myi file formats when I needed it in .sql.

Explained the situation to my new host, (which I would recommend to anyone, for the excellent tech support) They spent about an hour trying to access the old phpMyAdmin to do a dump and kept failing. They requested that I ask the server to transfer the full database contents (structure and data) to a file in the main directory and even then it took them almost half an hour to do the transfer, but it was installed smoothly and without a hiccup.

If you haven't been able to do the full database transfer, I'd suggest calling new host and requesting a direct server-to-server transfer.

Mudusa