Index of /andrejciho » 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

<code>
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');
</code>

<code>

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');

</code>

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

Leave a Comment