Index of /andrejciho/WordPress/Moving WordPress to a different URL

Post Title	Posted	Description
Parent Directory
Moving WordPress to a different URL	2008-04-25 11:48	A set of DB queries to help switch the URL

I've mentioned this in the past in my Nightly Mysql Backup but just recently realized I also have to update the guid

UPDATE wp_posts
SET post_content = REPLACE(post_content,'localhost/test','www.example.com'),
guid = REPLACE(guid,'localhost/test','www.example.com');
UPDATE wp_options
SET option_value = REPLACE(option_value,'localhost/test','www.example.com');