[SOLVED] Question about editing in phpmyadmin

Hello all! I donated and am waiting for Juggledad to get me in the Gold forum but meanwhile I have a question.

First I have to say I love this theme, it is the best I have seen so far! I went through 5 before I found one I could work with. This is my first wordpress site, I think I am going to do everything in wordpress from now on! I can't wait to see what you guys do next.

Anyway my question is, I downloaded this to a server in my unlimited hosting account. I set up the domain as I would for any other site and it does take you to the page but when you go anywhere else it shows the domain of the root where the database is located. I went in and did a browse under wp_posts and found all occurrences and changed them to the right domain. But it still isn't showing. Is there a step I am missing here? And for future reference, is there a way to set these up in an unlimited hosting account so I don't have to go in manually like this every time or am I always going to have to go and get a separate hosting account under the domain name attached to the site?

The domain for the site is http://www.hearttheearth.org and the location where the database is http://www.bosshi.com/blog

MAHALO!
dani