Running a test site

Just putting up a new blog and installed it originally into a sub-domain thinking I could easily transfer it. I couldn’t. I had to edit all the tables and a few files or am I missing something?