SQL required to move a WordPress Site to a new domain

To move a wordpress site from one domain to another, you need to execute the following SQL scripts on the database:
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 works as of WordPress 2.8.

"The site has consistently attracted praise and admiration from around the world"

Alan McCaffery
Chairman IRAC

Think we may be able to help you? Why not start a conversation - chances are, you'll go away with some new ideas and knowledge.