在wordpress数据库中替换网站URL

Im transfering a wordpress site from one domain to another. got the db integrated and the files in through FTP.

How do I replace all of the DB entries from http://url1.com to http://url2.com?

I tried this through SQL but it didnt work.

SELECT REPLACE('www.url1.com', 'url1', 'url2');

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

3条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
douhao2856 2015-08-12 07:10
关注
Use Better Search Replace Plugin.

https://wordpress.org/plugins/better-search-replace/

It is very simple. Before it replaces anything in the database, it will show the number rows that will be affected by running a Dry Run.

I recently used it and it worked flawlessly.

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(2条)

报告相同问题？

关注问题

在wordpress数据库中替换网站URL database mysql php
2015-08-12 03:47

回答 3 已采纳 Use Better Search Replace Plugin. https://wordpress.org/plugins/better-search-replace/ It is ver
在wordpress中重写URL 2次 php
2018-10-18 19:37

回答 1 已采纳 Try combine: function rewrite_state_url(){ add_rewrite_rule('^get-help/([^/]*)/([^/]*)/([^/
如何在wordpress中设置自定义页面URL javascript php
2018-07-18 21:14

回答 1 已采纳 If i were you i would follow these steps. Create a new page with name of Custom download maybe c
wordpress 数据库_如何在WordPress中创建视频库（逐步）
2020-09-05 08:33

cumohuo9136的博客 wordpress 数据库Recently, a user asked us how to create a video gallery in WordPress. WordPress makes it easy to embed videos in your blog posts, but it does not allow you to create video galleries ...
在Wordpress中自定义URL的形成 php
2015-07-07 15:29

回答 1 已采纳 You can put the artist name in a Custom Field, and then use some plugin to execute PHP in the post
更改wordpress旧图像路径url不会使用SQL反映在我的数据库中 php
2019-05-02 07:38

回答 1 已采纳 I managed to solve this issue by editing my wp-config.php First one will change all [Images,Plug
在wordpress中查找并替换html标头标签 php
2016-09-27 17:12

回答 1 已采纳 you can hook into the WP SEO 'wpseo_robots' hook like this: <?php // add the filter using an a
使用phpMyAdmin进行WordPress数据库管理的初学者指南
2020-09-12 12:15

cumyupx7788305的博客 WordPress is written using PHP as its scripting language and MySQL as its database management system. In order to use WordPress, you don’t really need to learn either of them. WordPress是使用PHP...
在WordPress中使用脚本URL的最佳方法 php
2017-08-02 18:45

回答 1 已采纳 You should try like this code: //page url: http://www.example/myurl add_action( 'init', 'my_rewr
将表单数据存储到wordpress数据库中 database php
2016-05-19 05:11

回答 2 已采纳 global $wpdb; $wpdb->insert( 'table_name', array( 'field_name' => $_POST['r1s1'], 'field_nam
如何在Wordpress中以编程方式重定向URL？ php
2017-04-19 09:15

回答 1 已采纳 What I think you want to achieve is to add a new redirect in your submenu. Then in the CPT overvie
wordpress链接跳转_如何隐藏WordPress网站上的会员链接
2020-09-08 04:10

cumohuo9136的博客 wordpress链接跳转Do you want to cloak affiliate links on your WordPress site? Not sure what does link cloaking means? In this article, we will explain what is link cloaking, and how you can cloak ...
如何在Wordpress中使用类别slug url？ php
2015-06-29 02:40

回答 1 已采纳 Maybe it will help some one else with this answer. The right code is: $category = get_the_categor
如何使用ThirstyAffiliates在WordPress中添加会员链接
2020-09-10 03:08

cumyupx7788305的博客 We are often asked about affiliate marketing tips for WordPress powered blogs and websites. What is the secret to affiliate marketing success? What is the best affiliate marketing plugin for WordPress...
wordpress添加媒体_如何在WordPress中添加新帖子并利用所有功能
2020-09-03 17:48

cumyupx7788305的博客 wordpress添加媒体Are you trying to create a new post in WordPress? Do you want to learn about all the WordPress ... 您是否要在WordPress中创建新帖子？您是否想了解屏幕上显示的所有WordPress帖子功能？ W...
没有解决我的问题, 去提问

悬赏问题

¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场部分对应不上
¥15 如何在scanpy上做差异基因和通路富集？
¥20 关于#硬件工程#的问题，请各位专家解答！
¥15 关于#matlab#的问题：期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707，使系统具有较小的超调量
¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
¥30 截图中的mathematics程序转换成matlab
¥15 动力学代码报错，维度不匹配
¥15 Power query添加列问题
¥50 Kubernetes&Fission&Eleasticsearch
¥15 報錯：Person is not mapped，如何解決？

在wordpress数据库中替换网站URL

3条回答 默认 最新

悬赏问题

3条回答默认最新