Advanced Search

Return to Snippet

Revision: 20640
at August 19, 2011 10:10 by beneberle
Updated Code 
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/');

Revision: 20639
at April 29, 2011 03:02 by beneberle
Updated Code 
UPDATE wp_posts SET post_content = replace(post_content, '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/');

Revision: 20638
at April 29, 2011 03:00 by beneberle
Updated Code 
UPDATE wp_posts SET post_content = replace(post_content, '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/');

Revision: 20637
at November 20, 2009 11:34 by beneberle
Initial Code 
UPDATE wp_posts SET post_content = replace(post_content, '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/');
Initial URL 









Initial Description





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!









Initial Title





Wordpress: Local To Remote Procedures









Initial Tags





mysql, wordpress









Initial Language





MySQL