Guest User

Untitled

a guest
Jul 16th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. function get_current_site() {
  2. global $current_site;
  3. return $current_site;
  4. }
  5.  
  6. USE `database_name`;
  7. UPDATE `wp_options` AS `o1` SET `o1`.`option_value` = REPLACE(`o1`.`option_value`, 'www.old-domain.com', 'www.new-domain.com') WHERE `o1`.`option_name` IN (
  8. 'siteurl',
  9. 'home'
  10. );
  11. UPDATE `wp_options` AS `o2` SET `o2`.`option_value` = REPLACE(`o2`.`option_value`, 'www.old-domain.com', 'www.new-domain.com') WHERE `o2`.`option_name` IN (
  12. 'siteurl',
  13. 'home'
  14. );
  15. UPDATE `wp_posts` AS `p1` SET `p1`.`guid` = REPLACE(`p1`.`guid`, 'www.old-domain.com', 'www.new-domain.com');
  16. UPDATE `wp_2_posts` AS `p2` SET `p2`.`guid` = REPLACE(`p2`.`guid`, 'www.old-domain.com', 'www.new-domain.com');
  17. UPDATE `wp_blogs` AS `b` SET `b`.`domain` = REPLACE(`b`.`domain`, 'www.old-domain.com', 'www.new-domain.com');
  18. UPDATE `wp_site` AS `s` SET `s`.`domain` = REPLACE(`s`.`domain`, 'www.old-domain.com', 'www.new-domain.com');
  19. UPDATE `wp_sitemeta` AS `sm` SET `sm`.`meta_value` = REPLACE(`sm`.`meta_value`, 'www.old-domain.com', 'www.new-domain.com');
  20. UPDATE `wp_usermeta` AS `um` SET `um`.`meta_value` = REPLACE(`um`.`meta_value`, 'www.old-domain.com', 'www.new-domain.com');
  21.  
  22. define('WP_HOME', 'http://www.old-domain.com');
  23. define('WP_SITEURL', 'http://www.old-domain.com');
  24.  
  25. replace: "olddomaim.com" with: "newdomain.com"
  26. and > "live run"
  27.  
  28. replace: "www.domain.com" with: "domain.com"
  29. and > "live run"
  30.  
  31. replace: "domain.com" with: "www.domain.com"
  32. and > "live run"
Add Comment
Please, Sign In to add comment