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,
'http://www.old.com','http://www.new.com');
Drink tea!
/ Adam