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.

"Iain marries technical ability with an understanding of the project's bigger picture and the needs of its stakeholders”

Laurence Hughes
Technical Director 2FluidCreative

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.