Thanks for that, great stuff!

What is the best format for sql export/import?

I use PHPMyAdmin (Usually in your host's control panel)
Select Export. Select the database.
Select SQL radio button.
At the bottom of the page choose save as file.

I followed the steps. When I go to the site site url (hosted with the new host) I receive a box asking If I want to download a file. I am not able to get past this point. Do you know what may have went wrong?

You may wish to make sure you have uploaded the files correctly into the server. You can always put a test file up there, and see if it works.
Just put a test.html with the contents "hello world"
When you go to yourdomain.com/test.html it should display the text "hello world"
If not - there may be an issue with the server, or the DNS settings (Where you registered your domain vs where it's hosted)

Can you give us a link so we can check?
Thanks
Phil

for all moving a site questions, all most all can be resolved by following the following step by step tutorial

http://www.concrete5.org/documentation/installation/moving_a_site...

Here is the absolute link to the account in which the installation was performed at the root level

http://184.154.7.26/~landsmac

I also have localhost as the db server name. This is how it was set up on the other host.