在 Localhost 中更改站点 URL 和 WordPress URL [英] Change site URL and WordPress URL in Localhost

问题描述

我在 Wordpress 工作.我的系统本地主机 url 是 http://localhost:8080/wordpress.
我想将我们的网站转移到另一个系统.

I am work in Wordpress. And my system localhost url is http://localhost:8080/wordpress.
I want to shift our site another system.

我的问题是我的另一个系统本地主机 url 是 http://localhost/wordpress(不包括 8080).所以你能帮我看看我们数据库中有多少表更新

My problem is that my another system localhost url is http://localhost/wordpress (not include 8080). So can you help me that is how many table update in our database

推荐答案

我使用以下查询来更新站点的域名

I use the following queries to update domain name of the site

UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';

UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';

UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');

UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');

只需更改 http://old-domain-name.com 和 http://new-domain-name.com 到适当的域名.这应该对您有所帮助.

Just change http://old-domain-name.com and http://new-domain-name.com to appropriate domain names. This should help you.

这篇关于在 Localhost 中更改站点 URL 和 WordPress URL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！