### [dedecms V5.7怎么修改表前缀](https://www.prosaas.cn/article/8078)

**Published:** 2019-12-02T02:56:48

**Author:** 5201314

**Excerpt:** dedecms V5.7怎么修改表前缀？dedecms V5.7修改表前缀的方法及出现不显示文章内容的解决方法…

**![](//zhiqipro.oss-cn-beijing.aliyuncs.com/2023/12/20231212130815965.jpg)**

**dedecms V5.7怎么修改表前缀？**

dedecms V5.7修改表前缀的方法及出现不显示文章内容的解决方法

推荐学习：织梦cms

首先进入mysql数据库的data目录；

然后将下面的内容保存为 pre.bat 内容可以使用记事本批量替换成你的表前缀和想要改成的前缀. window下的ren命令是重命名的.

如果在linux环境下,修改这些文件名就更简单了. 只需要一句命令 rename 'dede' 'linuxso' \*

ren dede\_addonarticle.frm linuxso\_addonarticle.frm
ren dede\_addonarticle.MYD linuxso\_addonarticle.MYD
ren dede\_addonarticle.MYI linuxso\_addonarticle.MYI
ren dede\_addonimages.frm linuxso\_addonimages.frm
ren dede\_addonimages.MYD linuxso\_addonimages.MYD
ren dede\_addonimages.MYI linuxso\_addonimages.MYI
ren dede\_addoninfos.frm linuxso\_addoninfos.frm
ren dede\_addoninfos.MYD linuxso\_addoninfos.MYD
ren dede\_addoninfos.MYI linuxso\_addoninfos.MYI
ren dede\_addonshop.frm linuxso\_addonshop.frm
ren dede\_addonshop.MYD linuxso\_addonshop.MYD
ren dede\_addonshop.MYI linuxso\_addonshop.MYI
ren dede\_addonsoft.frm linuxso\_addonsoft.frm
ren dede\_addonsoft.MYD linuxso\_addonsoft.MYD
ren dede\_addonsoft.MYI linuxso\_addonsoft.MYI
ren dede\_addonspec.frm linuxso\_addonspec.frm
ren dede\_addonspec.MYD linuxso\_addonspec.MYD
ren dede\_addonspec.MYI linuxso\_addonspec.MYI
ren dede\_admin.frm linuxso\_admin.frm
ren dede\_admin.MYD linuxso\_admin.MYD
ren dede\_admin.MYI linuxso\_admin.MYI
ren dede\_admintype.frm linuxso\_admintype.frm
ren dede\_admintype.MYD linuxso\_admintype.MYD
ren dede\_admintype.MYI linuxso\_admintype.MYI
ren dede\_advancedsearch.frm linuxso\_advancedsearch.frm
ren dede\_advancedsearch.MYD linuxso\_advancedsearch.MYD
ren dede\_advancedsearch.MYI linuxso\_advancedsearch.MYI
ren dede\_arcatt.frm linuxso\_arcatt.frm
ren dede\_arcatt.MYD linuxso\_arcatt.MYD
ren dede\_arcatt.MYI linuxso\_arcatt.MYI
ren dede\_arccache.frm linuxso\_arccache.frm
ren dede\_arccache.MYD linuxso\_arccache.MYD
ren dede\_arccache.MYI linuxso\_arccache.MYI
ren dede\_archives.frm linuxso\_archives.frm
ren dede\_archives.MYD linuxso\_archives.MYD
ren dede\_archives.MYI linuxso\_archives.MYI
ren dede\_arcrank.frm linuxso\_arcrank.frm
ren dede\_arcrank.MYD linuxso\_arcrank.MYD
ren dede\_arcrank.MYI linuxso\_arcrank.MYI
ren dede\_arctiny.frm linuxso\_arctiny.frm
ren dede\_arctiny.MYD linuxso\_arctiny.MYD
ren dede\_arctiny.MYI linuxso\_arctiny.MYI
ren dede\_arctype.frm linuxso\_arctype.frm
ren dede\_arctype.MYD linuxso\_arctype.MYD
ren dede\_arctype.MYI linuxso\_arctype.MYI
ren dede\_area.frm linuxso\_area.frm
ren dede\_area.MYD linuxso\_area.MYD
ren dede\_area.MYI linuxso\_area.MYI
ren dede\_ask.frm linuxso\_ask.frm
ren dede\_ask.MYD linuxso\_ask.MYD
ren dede\_ask.MYI linuxso\_ask.MYI
ren dede\_askanswer.frm linuxso\_askanswer.frm
ren dede\_askanswer.MYD linuxso\_askanswer.MYD
ren dede\_askanswer.MYI linuxso\_askanswer.MYI
ren dede\_asktype.frm linuxso\_asktype.frm
ren dede\_asktype.MYD linuxso\_asktype.MYD
ren dede\_asktype.MYI linuxso\_asktype.MYI
ren dede\_channeltype.frm linuxso\_channeltype.frm
ren dede\_channeltype.MYD linuxso\_channeltype.MYD
ren dede\_channeltype.MYI linuxso\_channeltype.MYI
ren dede\_co\_htmls.frm linuxso\_co\_htmls.frm
ren dede\_co\_htmls.MYD linuxso\_co\_htmls.MYD
ren dede\_co\_htmls.MYI linuxso\_co\_htmls.MYI
ren dede\_co\_mediaurls.frm linuxso\_co\_mediaurls.frm
ren dede\_co\_mediaurls.MYD linuxso\_co\_mediaurls.MYD
ren dede\_co\_mediaurls.MYI linuxso\_co\_mediaurls.MYI
ren dede\_co\_note.frm linuxso\_co\_note.frm
ren dede\_co\_note.MYD linuxso\_co\_note.MYD
ren dede\_co\_note.MYI linuxso\_co\_note.MYI
ren dede\_co\_onepage.frm linuxso\_co\_onepage.frm
ren dede\_co\_onepage.MYD linuxso\_co\_onepage.MYD
ren dede\_co\_onepage.MYI linuxso\_co\_onepage.MYI
ren dede\_co\_urls.frm linuxso\_co\_urls.frm
ren dede\_co\_urls.MYD linuxso\_co\_urls.MYD
ren dede\_co\_urls.MYI linuxso\_co\_urls.MYI
ren dede\_diyforms.frm linuxso\_diyforms.frm
ren dede\_diyforms.MYD linuxso\_diyforms.MYD
ren dede\_diyforms.MYI linuxso\_diyforms.MYI
ren dede\_downloads.frm linuxso\_downloads.frm
ren dede\_downloads.MYD linuxso\_downloads.MYD
ren dede\_downloads.MYI linuxso\_downloads.MYI
ren dede\_erradd.frm linuxso\_erradd.frm
ren dede\_erradd.MYD linuxso\_erradd.MYD
ren dede\_erradd.MYI linuxso\_erradd.MYI
ren dede\_feedback.frm linuxso\_feedback.frm
ren dede\_feedback.MYD linuxso\_feedback.MYD
ren dede\_feedback.MYI linuxso\_feedback.MYI
ren dede\_flink.frm linuxso\_flink.frm
ren dede\_flink.MYD linuxso\_flink.MYD
ren dede\_flink.MYI linuxso\_flink.MYI
ren dede\_flinktype.frm linuxso\_flinktype.frm
ren dede\_flinktype.MYD linuxso\_flinktype.MYD
ren dede\_flinktype.MYI linuxso\_flinktype.MYI
ren dede\_freelist.frm linuxso\_freelist.frm
ren dede\_freelist.MYD linuxso\_freelist.MYD
ren dede\_freelist.MYI linuxso\_freelist.MYI
ren dede\_groups.frm linuxso\_groups.frm
ren dede\_groups.MYD linuxso\_groups.MYD
ren dede\_groups.MYI linuxso\_groups.MYI
ren dede\_group\_guestbook.frm linuxso\_group\_guestbook.frm
ren dede\_group\_guestbook.MYD linuxso\_group\_guestbook.MYD
ren dede\_group\_guestbook.MYI linuxso\_group\_guestbook.MYI
ren dede\_group\_notice.frm linuxso\_group\_notice.frm
ren dede\_group\_notice.MYD linuxso\_group\_notice.MYD
ren dede\_group\_notice.MYI linuxso\_group\_notice.MYI
ren dede\_group\_posts.frm linuxso\_group\_posts.frm
ren dede\_group\_posts.MYD linuxso\_group\_posts.MYD
ren dede\_group\_posts.MYI linuxso\_group\_posts.MYI
ren dede\_group\_smalltypes.frm linuxso\_group\_smalltypes.frm
ren dede\_group\_smalltypes.MYD linuxso\_group\_smalltypes.MYD
ren dede\_group\_smalltypes.MYI linuxso\_group\_smalltypes.MYI
ren dede\_group\_threads.frm linuxso\_group\_threads.frm
ren dede\_group\_threads.MYD linuxso\_group\_threads.MYD
ren dede\_group\_threads.MYI linuxso\_group\_threads.MYI
ren dede\_group\_user.frm linuxso\_group\_user.frm
ren dede\_group\_user.MYD linuxso\_group\_user.MYD
ren dede\_group\_user.MYI linuxso\_group\_user.MYI
ren dede\_guestbook.frm linuxso\_guestbook.frm
ren dede\_guestbook.MYD linuxso\_guestbook.MYD
ren dede\_guestbook.MYI linuxso\_guestbook.MYI
ren dede\_homepageset.frm linuxso\_homepageset.frm
ren dede\_homepageset.MYD linuxso\_homepageset.MYD
ren dede\_homepageset.MYI linuxso\_homepageset.MYI
ren dede\_keywords.frm linuxso\_keywords.frm
ren dede\_keywords.MYD linuxso\_keywords.MYD
ren dede\_keywords.MYI linuxso\_keywords.MYI
ren dede\_log.frm linuxso\_log.frm
ren dede\_log.MYD linuxso\_log.MYD
ren dede\_log.MYI linuxso\_log.MYI
ren dede\_member.frm linuxso\_member.frm
ren dede\_member.MYD linuxso\_member.MYD
ren dede\_member.MYI linuxso\_member.MYI
ren dede\_member\_archives.frm linuxso\_member\_archives.frm
ren dede\_member\_archives.MYD linuxso\_member\_archives.MYD
ren dede\_member\_archives.MYI linuxso\_member\_archives.MYI
ren dede\_member\_company.frm linuxso\_member\_company.frm
ren dede\_member\_company.MYD linuxso\_member\_company.MYD
ren dede\_member\_company.MYI linuxso\_member\_company.MYI
ren dede\_member\_flink.frm linuxso\_member\_flink.frm
ren dede\_member\_flink.MYD linuxso\_member\_flink.MYD
ren dede\_member\_flink.MYI linuxso\_member\_flink.MYI
ren dede\_member\_friends.frm linuxso\_member\_friends.frm
ren dede\_member\_friends.MYD linuxso\_member\_friends.MYD
ren dede\_member\_friends.MYI linuxso\_member\_friends.MYI
ren dede\_member\_guestbook.frm linuxso\_member\_guestbook.frm
ren dede\_member\_guestbook.MYD linuxso\_member\_guestbook.MYD
ren dede\_member\_guestbook.MYI linuxso\_member\_guestbook.MYI
ren dede\_member\_operation.frm linuxso\_member\_operation.frm
ren dede\_member\_operation.MYD linuxso\_member\_operation.MYD
ren dede\_member\_operation.MYI linuxso\_member\_operation.MYI
ren dede\_member\_person.frm linuxso\_member\_person.frm
ren dede\_member\_person.MYD linuxso\_member\_person.MYD
ren dede\_member\_person.MYI linuxso\_member\_person.MYI
ren dede\_member\_pms.frm linuxso\_member\_pms.frm
ren dede\_member\_pms.MYD linuxso\_member\_pms.MYD
ren dede\_member\_pms.MYI linuxso\_member\_pms.MYI
ren dede\_member\_space.frm linuxso\_member\_space.frm
ren dede\_member\_space.MYD linuxso\_member\_space.MYD
ren dede\_member\_space.MYI linuxso\_member\_space.MYI
ren dede\_member\_stow.frm linuxso\_member\_stow.frm
ren dede\_member\_stow.MYD linuxso\_member\_stow.MYD
ren dede\_member\_stow.MYI linuxso\_member\_stow.MYI
ren dede\_member\_time.frm linuxso\_member\_time.frm
ren dede\_member\_time.MYD linuxso\_member\_time.MYD
ren dede\_member\_time.MYI linuxso\_member\_time.MYI
ren dede\_member\_tj.frm linuxso\_member\_tj.frm
ren dede\_member\_tj.MYD linuxso\_member\_tj.MYD
ren dede\_member\_tj.MYI linuxso\_member\_tj.MYI
ren dede\_member\_type.frm linuxso\_member\_type.frm
ren dede\_member\_type.MYD linuxso\_member\_type.MYD
ren dede\_member\_type.MYI linuxso\_member\_type.MYI
ren dede\_member\_vhistory.frm linuxso\_member\_vhistory.frm
ren dede\_member\_vhistory.MYD linuxso\_member\_vhistory.MYD
ren dede\_member\_vhistory.MYI linuxso\_member\_vhistory.MYI
ren dede\_moneycard\_record.frm linuxso\_moneycard\_record.frm
ren dede\_moneycard\_record.MYD linuxso\_moneycard\_record.MYD
ren dede\_moneycard\_record.MYI linuxso\_moneycard\_record.MYI
ren dede\_moneycard\_type.frm linuxso\_moneycard\_type.frm
ren dede\_moneycard\_type.MYD linuxso\_moneycard\_type.MYD
ren dede\_moneycard\_type.MYI linuxso\_moneycard\_type.MYI
ren dede\_mtypes.frm linuxso\_mtypes.frm
ren dede\_mtypes.MYD linuxso\_mtypes.MYD
ren dede\_mtypes.MYI linuxso\_mtypes.MYI
ren dede\_myad.frm linuxso\_myad.frm
ren dede\_myad.MYD linuxso\_myad.MYD
ren dede\_myad.MYI linuxso\_myad.MYI
ren dede\_mynews.frm linuxso\_mynews.frm
ren dede\_mynews.MYD linuxso\_mynews.MYD
ren dede\_mynews.MYI linuxso\_mynews.MYI
ren dede\_mytag.frm linuxso\_mytag.frm
ren dede\_mytag.MYD linuxso\_mytag.MYD
ren dede\_mytag.MYI linuxso\_mytag.MYI
ren dede\_plus.frm linuxso\_plus.frm
ren dede\_plus.MYD linuxso\_plus.MYD
ren dede\_plus.MYI linuxso\_plus.MYI
ren dede\_pwd\_tmp.frm linuxso\_pwd\_tmp.frm
ren dede\_pwd\_tmp.MYD linuxso\_pwd\_tmp.MYD
ren dede\_pwd\_tmp.MYI linuxso\_pwd\_tmp.MYI
ren dede\_ratings.frm linuxso\_ratings.frm
ren dede\_ratings.MYD linuxso\_ratings.MYD
ren dede\_ratings.MYI linuxso\_ratings.MYI
ren dede\_scores.frm linuxso\_scores.frm
ren dede\_scores.MYD linuxso\_scores.MYD
ren dede\_scores.MYI linuxso\_scores.MYI
ren dede\_search\_cache.frm linuxso\_search\_cache.frm
ren dede\_search\_cache.MYD linuxso\_search\_cache.MYD
ren dede\_search\_cache.MYI linuxso\_search\_cache.MYI
ren dede\_search\_keywords.frm linuxso\_search\_keywords.frm
ren dede\_search\_keywords.MYD linuxso\_search\_keywords.MYD
ren dede\_search\_keywords.MYI linuxso\_search\_keywords.MYI
ren dede\_sgpage.frm linuxso\_sgpage.frm
ren dede\_sgpage.MYD linuxso\_sgpage.MYD
ren dede\_sgpage.MYI linuxso\_sgpage.MYI
ren dede\_shops\_delivery.frm linuxso\_shops\_delivery.frm
ren dede\_shops\_delivery.MYD linuxso\_shops\_delivery.MYD
ren dede\_shops\_delivery.MYI linuxso\_shops\_delivery.MYI
ren dede\_shops\_orders.frm linuxso\_shops\_orders.frm
ren dede\_shops\_orders.MYD linuxso\_shops\_orders.MYD
ren dede\_shops\_orders.MYI linuxso\_shops\_orders.MYI
ren dede\_shops\_paytype.frm linuxso\_shops\_paytype.frm
ren dede\_shops\_paytype.MYD linuxso\_shops\_paytype.MYD
ren dede\_shops\_paytype.MYI linuxso\_shops\_paytype.MYI
ren dede\_shops\_products.frm linuxso\_shops\_products.frm
ren dede\_shops\_products.MYD linuxso\_shops\_products.MYD
ren dede\_shops\_products.MYI linuxso\_shops\_products.MYI
ren dede\_shops\_userinfo.frm linuxso\_shops\_userinfo.frm
ren dede\_shops\_userinfo.MYD linuxso\_shops\_userinfo.MYD
ren dede\_shops\_userinfo.MYI linuxso\_shops\_userinfo.MYI
ren dede\_softconfig.frm linuxso\_softconfig.frm
ren dede\_softconfig.MYD linuxso\_softconfig.MYD
ren dede\_softconfig.MYI linuxso\_softconfig.MYI
ren dede\_stepselect.frm linuxso\_stepselect.frm
ren dede\_stepselect.MYD linuxso\_stepselect.MYD
ren dede\_stepselect.MYI linuxso\_stepselect.MYI
ren dede\_store\_groups.frm linuxso\_store\_groups.frm
ren dede\_store\_groups.MYD linuxso\_store\_groups.MYD
ren dede\_store\_groups.MYI linuxso\_store\_groups.MYI
ren dede\_story\_books.frm linuxso\_story\_books.frm
ren dede\_story\_books.MYD linuxso\_story\_books.MYD
ren dede\_story\_books.MYI linuxso\_story\_books.MYI
ren dede\_story\_catalog.frm linuxso\_story\_catalog.frm
ren dede\_story\_catalog.MYD linuxso\_story\_catalog.MYD
ren dede\_story\_catalog.MYI linuxso\_story\_catalog.MYI
ren dede\_story\_chapter.frm linuxso\_story\_chapter.frm
ren dede\_story\_chapter.MYD linuxso\_story\_chapter.MYD
ren dede\_story\_chapter.MYI linuxso\_story\_chapter.MYI
ren dede\_story\_content.frm linuxso\_story\_content.frm
ren dede\_story\_content.MYD linuxso\_story\_content.MYD
ren dede\_story\_content.MYI linuxso\_story\_content.MYI
ren dede\_story\_viphistory.frm linuxso\_story\_viphistory.frm
ren dede\_story\_viphistory.MYD linuxso\_story\_viphistory.MYD
ren dede\_story\_viphistory.MYI linuxso\_story\_viphistory.MYI
ren dede\_sysconfig.frm linuxso\_sysconfig.frm
ren dede\_sysconfig.MYD linuxso\_sysconfig.MYD
ren dede\_sysconfig.MYI linuxso\_sysconfig.MYI
ren dede\_sys\_enum.frm linuxso\_sys\_enum.frm
ren dede\_sys\_enum.MYD linuxso\_sys\_enum.MYD
ren dede\_sys\_enum.MYI linuxso\_sys\_enum.MYI
ren dede\_sys\_module.frm linuxso\_sys\_module.frm
ren dede\_sys\_module.MYD linuxso\_sys\_module.MYD
ren dede\_sys\_module.MYI linuxso\_sys\_module.MYI
ren dede\_sys\_set.frm linuxso\_sys\_set.frm
ren dede\_sys\_set.MYD linuxso\_sys\_set.MYD
ren dede\_sys\_set.MYI linuxso\_sys\_set.MYI
ren dede\_tagindex.frm linuxso\_tagindex.frm
ren dede\_tagindex.MYD linuxso\_tagindex.MYD
ren dede\_tagindex.MYI linuxso\_tagindex.MYI
ren dede\_taglist.frm linuxso\_taglist.frm
ren dede\_taglist.MYD linuxso\_taglist.MYD
ren dede\_taglist.MYI linuxso\_taglist.MYI
ren dede\_uploads.frm linuxso\_uploads.frm
ren dede\_uploads.MYD linuxso\_uploads.MYD
ren dede\_uploads.MYI linuxso\_uploads.MYI
ren dede\_verifies.frm linuxso\_verifies.frm
ren dede\_verifies.MYD linuxso\_verifies.MYD
ren dede\_verifies.MYI linuxso\_verifies.MYI
ren dede\_vote.frm linuxso\_vote.frm
ren dede\_vote.MYD linuxso\_vote.MYD
ren dede\_vote.MYI linuxso\_vote.MYI

有些表可能没有列入,手动修改吧，没有几个。

修改完之后，问题就来了. 点击文章列表，是空的. 重新生成的静态html，只有标题，没有内容。怎么回事呢？

原来还需要修改一个表的内容. 用phpmyadmin 打开 linuxso\_channeltype 这个表，把里面的maintable列中的表名也修改一下 就OK了。

以上就是dedecms V5.7怎么修改表前缀的详细内容，更多请关注知企PROSAAS其它相关文章！

**Tags:** cms, DEDECMS, html, linux, mysql, phpMyAdmin, 数据库

**Categories:** DEDECMS

---