Wordpress | Change URL in Wordpress Database During Domain Change

wordpress-live-sweep.sql

// turn privacy setting off in Wordpress
UPDATE wp_options SET option_value = "1" WHERE option_name = "blog_public";
//change home and siteurl values
UPDATE wp_options SET option_value = "http://www.domain2.com" WHERE option_name = "home";
UPDATE wp_options SET option_value = "http://www.domain2.com" WHERE option_name = "siteurl"; 
// sweep options, post_content, and guid for references to old url
UPDATE wp_options SET option_value = REPLACE(option_value,'www.domain1.com','www.domain2.com');
UPDATE wp_posts SET post_content = REPLACE(post_content,'www.domain1.com','www.domain2.com'); 
UPDATE wp_posts SET guid = REPLACE(guid,'www.domain1.com','www.domain2.com');