When moving your WordPress blog to a new location on your server, you will need to update all the references in the database. The following MySql script can help with this task. Just run the following MySql in your query tool of choice. Make sure to replace the appropriate URLs.

UPDATE yourdb.wp_posts SET guid = REPLACE (guid, ‘http://yourdomain.com/oldlocation’, ‘http://yourdomain.com/newlocation’);

UPDATE yourdb.wp_posts SET post_content = REPLACE (post_content, ‘http://yourdomain.com/oldlocation’, ‘http://yourdomain.com/newlocation’);

This entry was posted on Wednesday, October 10th, 2007 at 4:34 pm and is filed under WordPress. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.