Transfer your wordpress install from one domain to another

To transfer your wordpress installation from one domain to another is not as simple as just moving the files, the reason for this is that they have used absolute URLs in the database for some reason.

You may also see the new wordpress installation switch domains in the address bar if you just transfer the file and then load up the website, as the links and redirects will all be set as the old domain.

You can move domains by runnning the following 3 queries with the old and new domains specified:
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

This changes the absolute URLs and allows your wordpress to show correctly on your new domain.