Wordpress updating URL paths after address change

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

If the official codex approach (http://codex.wordpress.org/Changing_The_Site_URL) is causing you problems, give this a try. Be sure to change the constant declarations and modify table names as necessary for your instance. Confirmed working with WP v3.4.

Copy this code and paste it in your HTML
  1. SET @current_path='site.dev.example.com',
  2. @new_path='site.stage.example.com';
  4. UPDATE wp_posts SET post_content = REPLACE(post_content, @current_path, @new_path);
  5. UPDATE wp_posts SET guid = REPLACE(guid, @current_path, @new_path);
  6. UPDATE wp_options SET option_value = REPLACE(option_value, @current_path, @new_path);
  7. UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, @current_path, @new_path);

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.