Posted By

beneberle on 11/20/09


Tagged

mysql wordpress


Versions (?)

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!

  1. UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://localhost:8888/', 'http://www.new-domain.com');
  2.  
  3. UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, 'http://localhost:8888/', 'http://www.new-domain.com');
  4.  
  5. UPDATE wp_posts SET guid = REPLACE(guid, 'http://localhost:8888/','http://www.new-domain.com');
  6.  
  7. UPDATE wp_options SET option_value = REPLACE(option_value, 'http://localhost:8888/', 'http://new-domain.com/');
  8.  
  9. UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'http://localhost:8888/', 'http://new-domain.com/');

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: afj176 on November 28, 2009

Totally awesome!!!!!

You need to login to post a comment.