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

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

将以下内容保存为pre.bat内容，可以用记事本替换为您的表前缀和您要更改的前缀。window下的ren命令被重命名。

进入mysql数据库的data目录
将下面的内容保存为pre.bat内容可以使用记事本批量替换成你的表前缀和想要改成的前缀.window下的ren命令是重命名的.
如果在linux环境下,修改这些文件名就更简单了.只需要一句命令rename'dede''linuxso'*
rendede_addonarticle.frmlinuxso_addonarticle.frm
rendede_addonarticle.MYDlinuxso_addonarticle.MYD
rendede_addonarticle.MYIlinuxso_addonarticle.MYI
rendede_addonimages.frmlinuxso_addonimages.frm
rendede_addonimages.MYDlinuxso_addonimages.MYD
rendede_addonimages.MYIlinuxso_addonimages.MYI
rendede_addoninfos.frmlinuxso_addoninfos.frm
rendede_addoninfos.MYDlinuxso_addoninfos.MYD
rendede_addoninfos.MYIlinuxso_addoninfos.MYI
rendede_addonshop.frmlinuxso_addonshop.frm
rendede_addonshop.MYDlinuxso_addonshop.MYD
rendede_addonshop.MYIlinuxso_addonshop.MYI
rendede_addonsoft.frmlinuxso_addonsoft.frm
rendede_addonsoft.MYDlinuxso_addonsoft.MYD
rendede_addonsoft.MYIlinuxso_addonsoft.MYI
rendede_addonspec.frmlinuxso_addonspec.frm
rendede_addonspec.MYDlinuxso_addonspec.MYD
rendede_addonspec.MYIlinuxso_addonspec.MYI
rendede_admin.frmlinuxso_admin.frm
rendede_admin.MYDlinuxso_admin.MYD
rendede_admin.MYIlinuxso_admin.MYI
rendede_admintype.frmlinuxso_admintype.frm
rendede_admintype.MYDlinuxso_admintype.MYD
rendede_admintype.MYIlinuxso_admintype.MYI
rendede_advancedsearch.frmlinuxso_advancedsearch.frm
rendede_advancedsearch.MYDlinuxso_advancedsearch.MYD
rendede_advancedsearch.MYIlinuxso_advancedsearch.MYI
rendede_arcatt.frmlinuxso_arcatt.frm
rendede_arcatt.MYDlinuxso_arcatt.MYD
rendede_arcatt.MYIlinuxso_arcatt.MYI
rendede_arccache.frmlinuxso_arccache.frm
rendede_arccache.MYDlinuxso_arccache.MYD
rendede_arccache.MYIlinuxso_arccache.MYI
rendede_archives.frmlinuxso_archives.frm
rendede_archives.MYDlinuxso_archives.MYD
rendede_archives.MYIlinuxso_archives.MYI
rendede_arcrank.frmlinuxso_arcrank.frm
rendede_arcrank.MYDlinuxso_arcrank.MYD
rendede_arcrank.MYIlinuxso_arcrank.MYI
rendede_arctiny.frmlinuxso_arctiny.frm
rendede_arctiny.MYDlinuxso_arctiny.MYD
rendede_arctiny.MYIlinuxso_arctiny.MYI
rendede_arctype.frmlinuxso_arctype.frm
rendede_arctype.MYDlinuxso_arctype.MYD
rendede_arctype.MYIlinuxso_arctype.MYI
rendede_area.frmlinuxso_area.frm
rendede_area.MYDlinuxso_area.MYD
rendede_area.MYIlinuxso_area.MYI
rendede_ask.frmlinuxso_ask.frm
rendede_ask.MYDlinuxso_ask.MYD
rendede_ask.MYIlinuxso_ask.MYI
rendede_askanswer.frmlinuxso_askanswer.frm
rendede_askanswer.MYDlinuxso_askanswer.MYD
rendede_askanswer.MYIlinuxso_askanswer.MYI
rendede_asktype.frmlinuxso_asktype.frm
rendede_asktype.MYDlinuxso_asktype.MYD
rendede_asktype.MYIlinuxso_asktype.MYI
rendede_channeltype.frmlinuxso_channeltype.frm
rendede_channeltype.MYDlinuxso_channeltype.MYD
rendede_channeltype.MYIlinuxso_channeltype.MYI
rendede_co_htmls.frmlinuxso_co_htmls.frm
rendede_co_htmls.MYDlinuxso_co_htmls.MYD
rendede_co_htmls.MYIlinuxso_co_htmls.MYI
rendede_co_mediaurls.frmlinuxso_co_mediaurls.frm
rendede_co_mediaurls.MYDlinuxso_co_mediaurls.MYD
rendede_co_mediaurls.MYIlinuxso_co_mediaurls.MYI
rendede_co_note.frmlinuxso_co_note.frm
rendede_co_note.MYDlinuxso_co_note.MYD
rendede_co_note.MYIlinuxso_co_note.MYI
rendede_co_onepage.frmlinuxso_co_onepage.frm
rendede_co_onepage.MYDlinuxso_co_onepage.MYD
rendede_co_onepage.MYIlinuxso_co_onepage.MYI
rendede_co_urls.frmlinuxso_co_urls.frm
rendede_co_urls.MYDlinuxso_co_urls.MYD
rendede_co_urls.MYIlinuxso_co_urls.MYI
rendede_diyforms.frmlinuxso_diyforms.frm
rendede_diyforms.MYDlinuxso_diyforms.MYD
rendede_diyforms.MYIlinuxso_diyforms.MYI
rendede_downloads.frmlinuxso_downloads.frm
rendede_downloads.MYDlinuxso_downloads.MYD
rendede_downloads.MYIlinuxso_downloads.MYI
rendede_erradd.frmlinuxso_erradd.frm
rendede_erradd.MYDlinuxso_erradd.MYD
rendede_erradd.MYIlinuxso_erradd.MYI
rendede_feedback.frmlinuxso_feedback.frm
rendede_feedback.MYDlinuxso_feedback.MYD
rendede_feedback.MYIlinuxso_feedback.MYI
rendede_flink.frmlinuxso_flink.frm
rendede_flink.MYDlinuxso_flink.MYD
rendede_flink.MYIlinuxso_flink.MYI
rendede_flinktype.frmlinuxso_flinktype.frm
rendede_flinktype.MYDlinuxso_flinktype.MYD
rendede_flinktype.MYIlinuxso_flinktype.MYI
rendede_freelist.frmlinuxso_freelist.frm
rendede_freelist.MYDlinuxso_freelist.MYD
rendede_freelist.MYIlinuxso_freelist.MYI
rendede_groups.frmlinuxso_groups.frm
rendede_groups.MYDlinuxso_groups.MYD
rendede_groups.MYIlinuxso_groups.MYI
rendede_group_guestbook.frmlinuxso_group_guestbook.frm
rendede_group_guestbook.MYDlinuxso_group_guestbook.MYD
rendede_group_guestbook.MYIlinuxso_group_guestbook.MYI
rendede_group_notice.frmlinuxso_group_notice.frm
rendede_group_notice.MYDlinuxso_group_notice.MYD
rendede_group_notice.MYIlinuxso_group_notice.MYI
rendede_group_posts.frmlinuxso_group_posts.frm
rendede_group_posts.MYDlinuxso_group_posts.MYD
rendede_group_posts.MYIlinuxso_group_posts.MYI
rendede_group_smalltypes.frmlinuxso_group_smalltypes.frm
rendede_group_smalltypes.MYDlinuxso_group_smalltypes.MYD
rendede_group_smalltypes.MYIlinuxso_group_smalltypes.MYI
rendede_group_threads.frmlinuxso_group_threads.frm
rendede_group_threads.MYDlinuxso_group_threads.MYD
rendede_group_threads.MYIlinuxso_group_threads.MYI
rendede_group_user.frmlinuxso_group_user.frm
rendede_group_user.MYDlinuxso_group_user.MYD
rendede_group_user.MYIlinuxso_group_user.MYI
rendede_guestbook.frmlinuxso_guestbook.frm
rendede_guestbook.MYDlinuxso_guestbook.MYD
rendede_guestbook.MYIlinuxso_guestbook.MYI
rendede_homepageset.frmlinuxso_homepageset.frm
rendede_homepageset.MYDlinuxso_homepageset.MYD
rendede_homepageset.MYIlinuxso_homepageset.MYI
rendede_keywords.frmlinuxso_keywords.frm
rendede_keywords.MYDlinuxso_keywords.MYD
rendede_keywords.MYIlinuxso_keywords.MYI
rendede_log.frmlinuxso_log.frm
rendede_log.MYDlinuxso_log.MYD
rendede_log.MYIlinuxso_log.MYI
rendede_member.frmlinuxso_member.frm
rendede_member.MYDlinuxso_member.MYD
rendede_member.MYIlinuxso_member.MYI
rendede_member_archives.frmlinuxso_member_archives.frm
rendede_member_archives.MYDlinuxso_member_archives.MYD
rendede_member_archives.MYIlinuxso_member_archives.MYI
rendede_member_company.frmlinuxso_member_company.frm
rendede_member_company.MYDlinuxso_member_company.MYD
rendede_member_company.MYIlinuxso_member_company.MYI
rendede_member_flink.frmlinuxso_member_flink.frm
rendede_member_flink.MYDlinuxso_member_flink.MYD
rendede_member_flink.MYIlinuxso_member_flink.MYI
rendede_member_friends.frmlinuxso_member_friends.frm
rendede_member_friends.MYDlinuxso_member_friends.MYD
rendede_member_friends.MYIlinuxso_member_friends.MYI
rendede_member_guestbook.frmlinuxso_member_guestbook.frm
rendede_member_guestbook.MYDlinuxso_member_guestbook.MYD
rendede_member_guestbook.MYIlinuxso_member_guestbook.MYI
rendede_member_operation.frmlinuxso_member_operation.frm
rendede_member_operation.MYDlinuxso_member_operation.MYD
rendede_member_operation.MYIlinuxso_member_operation.MYI
rendede_member_person.frmlinuxso_member_person.frm
rendede_member_person.MYDlinuxso_member_person.MYD
rendede_member_person.MYIlinuxso_member_person.MYI
rendede_member_pms.frmlinuxso_member_pms.frm
rendede_member_pms.MYDlinuxso_member_pms.MYD
rendede_member_pms.MYIlinuxso_member_pms.MYI
rendede_member_space.frmlinuxso_member_space.frm
rendede_member_space.MYDlinuxso_member_space.MYD
rendede_member_space.MYIlinuxso_member_space.MYI
rendede_member_stow.frmlinuxso_member_stow.frm
rendede_member_stow.MYDlinuxso_member_stow.MYD
rendede_member_stow.MYIlinuxso_member_stow.MYI
rendede_member_time.frmlinuxso_member_time.frm
rendede_member_time.MYDlinuxso_member_time.MYD
rendede_member_time.MYIlinuxso_member_time.MYI
rendede_member_tj.frmlinuxso_member_tj.frm
rendede_member_tj.MYDlinuxso_member_tj.MYD
rendede_member_tj.MYIlinuxso_member_tj.MYI
rendede_member_type.frmlinuxso_member_type.frm
rendede_member_type.MYDlinuxso_member_type.MYD
rendede_member_type.MYIlinuxso_member_type.MYI
rendede_member_vhistory.frmlinuxso_member_vhistory.frm
rendede_member_vhistory.MYDlinuxso_member_vhistory.MYD
rendede_member_vhistory.MYIlinuxso_member_vhistory.MYI
rendede_moneycard_record.frmlinuxso_moneycard_record.frm
rendede_moneycard_record.MYDlinuxso_moneycard_record.MYD
rendede_moneycard_record.MYIlinuxso_moneycard_record.MYI
rendede_moneycard_type.frmlinuxso_moneycard_type.frm
rendede_moneycard_type.MYDlinuxso_moneycard_type.MYD
rendede_moneycard_type.MYIlinuxso_moneycard_type.MYI
rendede_mtypes.frmlinuxso_mtypes.frm
rendede_mtypes.MYDlinuxso_mtypes.MYD
rendede_mtypes.MYIlinuxso_mtypes.MYI
rendede_myad.frmlinuxso_myad.frm
rendede_myad.MYDlinuxso_myad.MYD
rendede_myad.MYIlinuxso_myad.MYI
rendede_mynews.frmlinuxso_mynews.frm
rendede_mynews.MYDlinuxso_mynews.MYD
rendede_mynews.MYIlinuxso_mynews.MYI
rendede_mytag.frmlinuxso_mytag.frm
rendede_mytag.MYDlinuxso_mytag.MYD
rendede_mytag.MYIlinuxso_mytag.MYI
rendede_plus.frmlinuxso_plus.frm
rendede_plus.MYDlinuxso_plus.MYD
rendede_plus.MYIlinuxso_plus.MYI
rendede_pwd_tmp.frmlinuxso_pwd_tmp.frm
rendede_pwd_tmp.MYDlinuxso_pwd_tmp.MYD
rendede_pwd_tmp.MYIlinuxso_pwd_tmp.MYI
rendede_ratings.frmlinuxso_ratings.frm
rendede_ratings.MYDlinuxso_ratings.MYD
rendede_ratings.MYIlinuxso_ratings.MYI
rendede_scores.frmlinuxso_scores.frm
rendede_scores.MYDlinuxso_scores.MYD
rendede_scores.MYIlinuxso_scores.MYI
rendede_search_cache.frmlinuxso_search_cache.frm
rendede_search_cache.MYDlinuxso_search_cache.MYD
rendede_search_cache.MYIlinuxso_search_cache.MYI
rendede_search_keywords.frmlinuxso_search_keywords.frm
rendede_search_keywords.MYDlinuxso_search_keywords.MYD
rendede_search_keywords.MYIlinuxso_search_keywords.MYI
rendede_sgpage.frmlinuxso_sgpage.frm
rendede_sgpage.MYDlinuxso_sgpage.MYD
rendede_sgpage.MYIlinuxso_sgpage.MYI
rendede_shops_delivery.frmlinuxso_shops_delivery.frm
rendede_shops_delivery.MYDlinuxso_shops_delivery.MYD
rendede_shops_delivery.MYIlinuxso_shops_delivery.MYI
rendede_shops_orders.frmlinuxso_shops_orders.frm
rendede_shops_orders.MYDlinuxso_shops_orders.MYD
rendede_shops_orders.MYIlinuxso_shops_orders.MYI
rendede_shops_paytype.frmlinuxso_shops_paytype.frm
rendede_shops_paytype.MYDlinuxso_shops_paytype.MYD
rendede_shops_paytype.MYIlinuxso_shops_paytype.MYI
rendede_shops_products.frmlinuxso_shops_products.frm
rendede_shops_products.MYDlinuxso_shops_products.MYD
rendede_shops_products.MYIlinuxso_shops_products.MYI
rendede_shops_userinfo.frmlinuxso_shops_userinfo.frm
rendede_shops_userinfo.MYDlinuxso_shops_userinfo.MYD
rendede_shops_userinfo.MYIlinuxso_shops_userinfo.MYI
rendede_softconfig.frmlinuxso_softconfig.frm
rendede_softconfig.MYDlinuxso_softconfig.MYD
rendede_softconfig.MYIlinuxso_softconfig.MYI
rendede_stepselect.frmlinuxso_stepselect.frm
rendede_stepselect.MYDlinuxso_stepselect.MYD
rendede_stepselect.MYIlinuxso_stepselect.MYI
rendede_store_groups.frmlinuxso_store_groups.frm
rendede_store_groups.MYDlinuxso_store_groups.MYD
rendede_store_groups.MYIlinuxso_store_groups.MYI
rendede_story_books.frmlinuxso_story_books.frm
rendede_story_books.MYDlinuxso_story_books.MYD
rendede_story_books.MYIlinuxso_story_books.MYI
rendede_story_catalog.frmlinuxso_story_catalog.frm
rendede_story_catalog.MYDlinuxso_story_catalog.MYD
rendede_story_catalog.MYIlinuxso_story_catalog.MYI
rendede_story_chapter.frmlinuxso_story_chapter.frm
rendede_story_chapter.MYDlinuxso_story_chapter.MYD
rendede_story_chapter.MYIlinuxso_story_chapter.MYI
rendede_story_content.frmlinuxso_story_content.frm
rendede_story_content.MYDlinuxso_story_content.MYD
rendede_story_content.MYIlinuxso_story_content.MYI
rendede_story_viphistory.frmlinuxso_story_viphistory.frm
rendede_story_viphistory.MYDlinuxso_story_viphistory.MYD
rendede_story_viphistory.MYIlinuxso_story_viphistory.MYI
rendede_sysconfig.frmlinuxso_sysconfig.frm
rendede_sysconfig.MYDlinuxso_sysconfig.MYD
rendede_sysconfig.MYIlinuxso_sysconfig.MYI
rendede_sys_enum.frmlinuxso_sys_enum.frm
rendede_sys_enum.MYDlinuxso_sys_enum.MYD
rendede_sys_enum.MYIlinuxso_sys_enum.MYI
rendede_sys_module.frmlinuxso_sys_module.frm
rendede_sys_module.MYDlinuxso_sys_module.MYD
rendede_sys_module.MYIlinuxso_sys_module.MYI
rendede_sys_set.frmlinuxso_sys_set.frm
rendede_sys_set.MYDlinuxso_sys_set.MYD
rendede_sys_set.MYIlinuxso_sys_set.MYI
rendede_tagindex.frmlinuxso_tagindex.frm
rendede_tagindex.MYDlinuxso_tagindex.MYD
rendede_tagindex.MYIlinuxso_tagindex.MYI
rendede_taglist.frmlinuxso_taglist.frm
rendede_taglist.MYDlinuxso_taglist.MYD
rendede_taglist.MYIlinuxso_taglist.MYI
rendede_uploads.frmlinuxso_uploads.frm
rendede_uploads.MYDlinuxso_uploads.MYD
rendede_uploads.MYIlinuxso_uploads.MYI
rendede_verifies.frmlinuxso_verifies.frm
rendede_verifies.MYDlinuxso_verifies.MYD
rendede_verifies.MYIlinuxso_verifies.MYI
rendede_vote.frmlinuxso_vote.frm
rendede_vote.MYDlinuxso_vote.MYD
rendede_vote.MYIlinuxso_vote.MYI
有些表可能没有列入,手动修改吧，没有几个。
修改完之后，问题就来了.点击文章列表，是空的.重新生成的静态html，只有标题，没有内容。怎么回事呢？
原来还需要修改一个表的内容.用phpmyadmin打开linuxso_channeltype这个表，把里面的maintable列中的表名也修改一下就OK了。