cosname

MySql for WP domain migration

May 22nd, 2014
240
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. UPDATE wp_posts SET guid = REPLACE(guid, <search_domain>, <replace_domain>);
  2. UPDATE wp_posts SET post_content = REPLACE(post_content, <search_domain>, <replace_domain>);
  3. UPDATE wp_options SET option_value = REPLACE(option_value, <search_domain>, <replace_domain>);
  4. UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, <search_domain>, <replace_domain>);
Advertisement
Add Comment
Please, Sign In to add comment