1,导出destoon数据,destoon新闻是分表存储的 通过itemid关联查询,保存到临时表
INSERT INTO mt_article_data_24_1 (catid,itemid,title,introduce,keyword,addtime,content) SELECT t1.catid,t1.itemid,t1.title,t1.introduce,t1.keyword,t1.addtime,t2.content FROM mt_article_24 as t1 JOIN mt_article_data_24 as t2 on t1.itemid = t2.itemid WHERE t1.catid="13"
2,导出成excel,然后把pb的文章表导出,替换内容后导入pb数据库里,最后把文章里的图片链接及文件复制过来完成搬家