This is just a note to self really, so I dont forget. Here is a summary of how to move a wordpress blog to a new domain: change wordpress domain name steps.
Going to copy and paste the contents here, in case the site goes down:
“0) prepare the new host information and new domain name address and the database host.
1) log in blog and go to Site Admin page, and in the Settings , change the WordPress Address(URL) and the Blog Address(URL) in the form and save it (when you done this, if you want to log in you should change the data in the database , it store in the table named wp_options).
2) log in phpmyadmin and select the current database, in the SQL form , you should copy the query string and paste it into the form and update the database.
a: For links and attachments in the conten. the query string is :
UPDATE `wp_posts` SET `post_content` = replace(post_content, ‘http://www.your-old-domain.com’, ‘http://www.your-new-domain.com’);
b: For the posts permalinks stored in the database. (By the way , you may skip this step):
UPDATE `wp_posts` SET `guid` = replace(guid, ‘http://www.your-old-domain.com’,'http://www.your-new-domain.com’);
c: If you created the custom filed in the post , you should copy this also:
UPDATE `wp_postmeta` SET `meta_value` = replace(meta_value, ‘http://www.your-old-domain.com’,'http://www.your-new-domain.com’);
3) export the current database and download to the local directory.
4) upload all files and import the exported database, if the database information is different , make sure check it correctly in wp-config.php in the blog root directory.
5) open browser and visit the new blog address , and there is it.”
Edit: actually, it’s more complicated than this: you probably need to update option_value in options, and a few other tables too, but using the above sql as a guideline it is fairly easy to change the others.