没想到换了域名后博客图片都挂了,目前已修复。附上typecho批量图片地址的SQL命令

分类:随笔 日期:2022-06-06 作者:caocaofff 浏览:122

由于我用的是typecho搭建的博客,所以知道了存放文章的表和字段。

UPDATE `typecho_contents` SET `text` = REPLACE(`text`,'cboot.org','blog.ccpe.net');

顺便修改支持了emoji表情,不然发表带emoji的文章会出现 Database Query Error

ALTER TABLE typecho_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE typecho_contents CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE typecho_fields CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE typecho_metas CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE typecho_options CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE typecho_relationships CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE typecho_users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

看样子还是要时不时上来看看才行🤣

评论 (暂无评论)

发表评论

昵称:  
邮箱:  
网址:

验证码:captcha