Wordpress: Local To Remote Procedures

/ Published in: MySQL
Save to your folder(s)

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
  1. UPDATE wp_posts SET post_content = replace(post_content, 'http://localhost:8888/', 'http://www.new-domain.com');
  3. UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, 'http://localhost:8888/', 'http://www.new-domain.com');
  5. UPDATE wp_posts SET guid = replace(guid, 'http://localhost:8888/','http://www.new-domain.com');
  7. UPDATE wp_options SET option_value = replace(option_value, 'http://localhost:8888/', 'http://new-domain.com/');
  9. UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://localhost:8888/', 'http://new-domain.com/');

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.