First thing, check the mysql version on the server you are copying from.
phpMyAdmin on that server should tell you the MySQL version. If it's 4.1 and the server you are copying to is 4.0 you will need to select "SQL export compatibility -> MYSQL40" when exporting.
On the server you are copying to:
Load up phpMyAdmin, on the left hand side of the page there will be 5 icons above the database dropdown. Select the 3rd Icon which is the Query Window. A new window will open up, choose the Import Files tab. Click Browse and locate the database dump file on your PC that should of been generated when exporting the database from the other server.
From there it's pretty self explanatory. If you get errors when importing, it could be the database is to large to import through phpMyAdmin. If so post back here and I will tell you how to import from SSH (Assuming you have that capability).
Alright, well I think I got it now, but the creation seems to be hanging.
It's a 75mb database, so how long do you suspect it'd take to finish?
It's been like this for a few minutes:
[email protected] [~]# mysql -u vikingla -p vikingla_vikinglandsptc < vikingla_vikinglandsptc-1.sql
I entered the password and now when I go to the site I see this error:
Database error: Invalid SQL: SELECT id FROM stats WHERE date='12/12/05'
MySQL Error: 1146 (Table 'vikingla_vikinglandsptc.stats' doesn't exist)
Those of us who are challenged by similar database issues, really appreciate your willingness to go public and ask for help. Because you doggedly pursued this to its conclusion, we've got a pretty nice tutorial built into this thread. Thanks.