点评：将下面的内容保存为 pre.bat 内容可以使用记事本批量替换成你的表前缀和想要改成的前缀. window下的ren命令是重命名的 进入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
未经允许不得转载：Str Tom工作室 » dedecms V5.7修改表前缀的方法及出现不显示文章内容的解决方法
各类知识收集，PHP技术分享与解决方案
