Geeklog: What I Learnt Today / Adam

Moving your wordpress blog to a new domain name

> I'm uploading this myself so i can find it allways seems to take a while to google it. Or if you just want to upload your local development copy to your online server.
Update your options

UPDATE wp_options SET option_value = replace(option_value,
'http://www.old.com', 'http://www.new.com') WHERE option_name = 'home'
OR option_name = 'siteurl';

If its all new and has few plugins this is only one line but after a while it can get repetitive in the options
Update your posts

UPDATE wp_posts SET guid = replace(guid,

Then you probably want to check the content of your posts for links and included image paths etc

SELECT * FROM wp_posts 
WHERE post_content like '%http://www.old.com%'

In an ideal world there won't be any hard coded url paths in post contents but unfortunately :)
Drink tea!

/ Adam