Thread: restoring wordpress database from domain.com to www.domain.com

i have site which is lately a domain.com but since i tried to change my hosting in this domain, changed its nameservers to my fatcow account and it turned out that it now has www.domain.com.
restoring it to this host work well except the posts.. viewing the www.domain.com looks good, yet when i tried to view www.domain.com/blogpost/ prompt me with 404 error

Page Not Found

The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. Please try the following:

• If you typed the page address in the Address bar, make sure that it is spelled correctly.
• Click the Back button in your browser to try another link.
• Use a search engine like Google to look for information on the Internet.

whats better solution to this?

internal links don't work

Did you check your config.php?
To make sure it has the correct database name, user and password?

Ya, specifically, did your username and db prefix change with the hosting shift? If so, then it could just be that simple
Of course, we are assuming you exported your previous WP database for the site and imported it again right? If you need more help just PM.
Cheers,
James

The first place I would look is with the DNS for your hosting. It should accommodate domains both with and without the www subdomain.

If your home page is working, but your post pages are not, you might want to make sure that permalinks are working. It could be that your .htaccess file has not been set up properly or your host does not allow the use of server overrides using the .htaccess file. If you cannot do URL rewrites, permalink URLs will not work.

indeed its the .htaccess
below the permalink page in wordpress dashboard, it suggested what the htaccess should be so i uploaded it and now the inner pages and blogposts can now be accessed