How to modify the table prefix in dedecms V5.7

dedecms V5.7 How to modify the table prefix?

dedecms V5.7 method to modify the table prefix and the solution to the problem of not displaying the article content

Recommended study: 梦Weavercms

First enter the data directory of the mysql database;

Then save the following content as pre.bat. The content can be replaced in batches with your table prefix and the prefix you want to change using Notepad. ren command under window It is renamed.

If you are in a Linux environment, it is easier to modify these file names. Just one command is needed: 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

Some tables may not have columns. Enter it and modify it manually, there are not many.

After the modification, the problem arises. Click on the article list, it is empty. The regenerated static html has only the title and no content. What's going on?

It turns out that I still need to modify the contents of a table. Use phpmyadmin to open the linuxso_channeltype table, and modify the table name in the maintable column inside. Then it will be OK.

The above is the detailed content of How to modify the table prefix in dedecms V5.7. For more information, please follow other related articles on the PHP Chinese website!