Posted By

beneberle on 11/20/09

Tagged

Versions (?)

Last Edited at 11/20/09 11:34am

Statistics

Viewed 763 times

Favorited by 0 user(s)

Related snippets

Wordpress: Local To Remote Procedures

/ Published in: MySQL

Just updated for WP 3 (added wp_postmeta table for menus)! Test out the new installation thoroughly but everything should be fine, and your CMS should be running live on the new server!

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

UPDATE wp_posts SET post_content = replace(post_content, 'http://localhost:8888/', 'http://www.new-domain.com');
 
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, 'http://localhost:8888/', 'http://www.new-domain.com');
 
UPDATE wp_posts SET guid = replace(guid, 'http://localhost:8888/','http://www.new-domain.com');
 
UPDATE wp_options SET option_value = replace(option_value, 'http://localhost:8888/', 'http://new-domain.com/');
 
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://localhost:8888/', 'http://new-domain.com/');