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

UPDATE `typecho_contents` SET `text` = REPLACE(`text`,'cboot.org','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;

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

CC版权： 本篇博文采用《CC 协议》，转载必须注明作者和本文链接