Wordpress: Local To Remote Procedures
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!
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/' ) ;
Report this snippet
Comments
Subscribe to comments