Loading... 最近几天本站一直被人打,于是我就想到了OSS没设置带宽封顶策略,于是开启缓存后OSS域名变更了,文章链接图片附件链接等全部失效,虽然网上有替换插件,但是没有改变数据库内容总感觉没从根本上解决问题,于是就利用SQL语句替换掉了域名,又可以访问了。开心 <img src="https://image.blogbig.cn/handsome/assets/img/emotion/aru/cheer.png" class="emotion-aru"> ## 事列 如OSS原域名:`blog-196.cos.ap-guangzhou.myqcloud.com` 现在的域名:`image.blogbig.cn` 则旧网址:`blog-196.cos.ap-guangzhou.myqcloud.com` 新网址:`image.blogbig.cn` ## 进入文章数据表 进入typecho_contents表(文章内容表)  ## SQL语句 点击“SQL”输入下面的语句,点击“执行” ```````````````````````````````````````````````````````````````````````````````` UPDATE `typecho_contents` SET `text` = REPLACE(`text`,'旧网址','新网址'); ````````````````````````````````````````````````````````````````````````````````  ## 同样替换typecho_fields表(文章字段表) 点击“SQL”输入下面的语句,点击“执行”。 ```````````````````````````````````````````````````````````````````````````````````````` UPDATE `typecho_fields` SET `str_value` = REPLACE(`str_value`,'旧网址','新网址'); ```````````````````````````````````````````````````````````````````````````````````````` ## 后言 替换还有很多用处,比如当网址配置SSL后需要更改链接。 则旧网址:`http://域名` 新网址:`https://域名` 其他系统替换大同小异,只需要改一下语句里的表名就ok啦。 正文到此结束 最后修改:2022 年 04 月 30 日 © 允许规范转载 打赏 赞赏作者 支付宝微信 赞 1 如果觉得我的文章对你有用,请随意赞赏