Advertisement
miriamdepaula

WordPress: SQL Queries to change URLs from DB

Oct 22nd, 2014
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.54 KB | None | 0 0
  1. UPDATE wp_options
  2. SET option_value = REPLACE(option_value, 'http://www.enderecoantigo.com', 'http://www.endereconovo.com')
  3. WHERE option_name = 'home'
  4. OR option_name = 'siteurl';
  5.  
  6.  
  7. UPDATE wp_posts
  8. SET guid = REPLACE (guid, 'http://www.enderecoantigo.com', 'http://www.endereconovo.com');
  9.  
  10.  
  11. UPDATE wp_posts
  12. SET post_content = REPLACE (post_content, 'http://www.enderecoantigo.com', 'http://www.endereconovo.com');
  13.  
  14.  
  15. UPDATE wp_postmeta
  16. SET meta_value = REPLACE (meta_value, 'http://www.enderecoantigo.com','http://www.endereconovo.com');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement