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 … read post