Advertisement
armin_san

Wordpress Migration - SQL

Sep 20th, 2011
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  1. # UPDATE options, but NOT those containing serialized arrays
  2. UPDATE wp_options SET option_value = REPLACE(option_value,'http://localhost/example','http://www.example.org') WHERE option_value NOT LIKE '%{%';
  3. UPDATE wp_posts SET guid = REPLACE(guid,'http://localhost/example','http://www.example.org');
  4. UPDATE wp_posts SET post_content = REPLACE(post_content,'http://localhost/example','http://www.example.org');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement