Advanced Search

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.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SET	@current_path='site.dev.example.com', 
  2. 	@new_path='site.stage.example.com';
  3.  
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.