本來認為應該很簡單可以解決, 但是發現還是有很多奇怪的地方, 記錄一下目前測試修改後正常運作的處理方式
<?php define('DB_NAME', 'wordpress'); define('DB_USER', 'wordpress_user'); define('DB_PASSWORD', 'wordpress_password'); define('DB_HOST', 'localhost'); : // Single-Site (serves any hostname) // For Multi-Site, see: https://www.turnkeylinux.org/docs/wordpress/multisite define('WP_SITEURL', 'http://'.$_SERVER['HTTP_HOST']); define('WP_HOME', 'http://'.$_SERVER['HTTP_HOST']); :
UPDATE wp_posts SET post_content = REPLACE(post_content, 'www.abc.com', 'www.xyz.com') WHERE post_content LIKE '%www.abc.com%'; UPDATE wp_posts SET guid= REPLACE(guid, 'www.abc.com', 'www.xyz.com') WHERE guid LIKE '%www.abc.com%'; UPDATE wp_options SET option_value = REPLACE(option_value, 'www.abc.com', 'www.xyz.com') WHERE option_value LIKE '%www.abc.com%';