UPDATE wp_options SET option_value = REPLACE (option_value, 'http://www.YOUR-OLD-DOMAIN.com', 'http://www.YOUR-NEW-DOMAIN.com') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = REPLACE (guid, 'http://www.YOUR-OLD-DOMAIN.com','http://www.YOUR-NEW-DOMAIN.com'); UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://www.YOUR-OLD-DOMAIN.com','http://www.YOUR-NEW-DOMAIN.com');