MySQL Database Transfer

[emo_boy]

I am changing hosts and I was using phpBB forum software with MySQL databases. When I transfer all my files and databases to the new host it doesnt work. This is the response I got back from my host, but I was wondering if you could give me a detailed 'how-to' to do this. And if it is true.

SQL Error : 1146 Table emoboy_xmb3.phpbb_users doesn exist is the right username.

This simply looks because your old host is running too early of a cPanel version, yet too old of a MySQL version, the old host is at MySQL 4.0.x, which we are are the current version of 4.1.x

You might want to try a full mysqldump via command line with the old host and restore that via command line with us, I have just enabled SSH with your account with us for when you need that.

Is there an easy way or better way to do this? I know this may not be the best place to ask, but I'm really new to this stuff. Thanks in advance!