dede官方数据库表前缀默认的是dede. 有朋友想要更改dede数据库表前缀,更改的好处可能有这样几条: 1、安全性更高 2、可以在同一个数据库中安装2个以上的织梦系统。
下面给一个更改dede官方数据库表前缀默认的是dede.
有朋友想要更改dede数据库表前缀,更改的好处可能有这样几条:
1、安全性更高
2、可以在同一个数据库中安装2个以上的织梦系统。
下面给一个更改dede数据库表前缀的方法，这个方法是我用过的最稳妥的方法。不会出现系统崩溃的情况。
1、进入dede系统后台，运行sql命令：(命令含义为将数据库前缀由dedeqiye改为dedqiye0)
找到“系统”----“SQL命令行工具”---输入以下命令，运行
RENAME TABLE dedeqiye_addonarticle TO dedeqiye0_addonarticle ;
RENAME TABLE dedeqiye_addonimages TO dedeqiye0_addonimages ;
RENAME TABLE dedeqiye_addoninfos TO dedeqiye0_addoninfos ;
RENAME TABLE dedeqiye_addonshop TO dedeqiye0_addonshop ;
RENAME TABLE dedeqiye_addonsoft TO dedeqiye0_addonsoft ;
RENAME TABLE dedeqiye_addonspec TO dedeqiye0_addonspec ;
RENAME TABLE dedeqiye_admin TO dedeqiye0_admin ;
RENAME TABLE dedeqiye_admintype TO dedeqiye0_admintype ;
RENAME TABLE dedeqiye_advancedsearch TO dedeqiye0_advancedsearch ;
RENAME TABLE dedeqiye_arcatt TO dedeqiye0_arcatt ;
RENAME TABLE dedeqiye_arccache TO dedeqiye0_arccache ;
RENAME TABLE dedeqiye_archives TO dedeqiye0_archives ;
RENAME TABLE dedeqiye_arcmulti TO dedeqiye0_arcmulti ;
RENAME TABLE dedeqiye_arcrank TO dedeqiye0_arcrank ;
RENAME TABLE dedeqiye_arctiny TO dedeqiye0_arctiny ;
RENAME TABLE dedeqiye_arctype TO dedeqiye0_arctype ;
RENAME TABLE dedeqiye_area TO dedeqiye0_area ;
RENAME TABLE dedeqiye_channeltype TO dedeqiye0_channeltype ;
RENAME TABLE dedeqiye_co_htmls TO dedeqiye0_co_htmls ;
RENAME TABLE dedeqiye_co_mediaurls TO dedeqiye0_co_mediaurls ;
RENAME TABLE dedeqiye_co_note TO dedeqiye0_co_note ;
RENAME TABLE dedeqiye_co_onepage TO dedeqiye0_co_onepage ;
RENAME TABLE dedeqiye_co_urls TO dedeqiye0_co_urls ;
RENAME TABLE dedeqiye_diyforms TO dedeqiye0_diyforms ;
RENAME TABLE dedeqiye_downloads TO dedeqiye0_downloads ;
RENAME TABLE dedeqiye_erradd TO dedeqiye0_erradd ;
RENAME TABLE dedeqiye_feedback TO dedeqiye0_feedback ;
RENAME TABLE dedeqiye_flink TO dedeqiye0_flink ;
RENAME TABLE dedeqiye_flinktype TO dedeqiye0_flinktype ;
RENAME TABLE dedeqiye_freelist TO dedeqiye0_freelist ;
RENAME TABLE dedeqiye_guestbook TO dedeqiye0_guestbook ;
RENAME TABLE dedeqiye_homepageset TO dedeqiye0_homepageset ;
RENAME TABLE dedeqiye_keywords TO dedeqiye0_keywords ;
RENAME TABLE dedeqiye_log TO dedeqiye0_log ;
RENAME TABLE dedeqiye_member TO dedeqiye0_member ;
RENAME TABLE dedeqiye_member_company TO dedeqiye0_member_company ;
RENAME TABLE dedeqiye_member_feed TO dedeqiye0_member_feed ;
RENAME TABLE dedeqiye_member_flink TO dedeqiye0_member_flink ;
RENAME TABLE dedeqiye_member_friends TO dedeqiye0_member_friends ;
RENAME TABLE dedeqiye_member_group TO dedeqiye0_member_group ;
RENAME TABLE dedeqiye_member_guestbook TO dedeqiye0_member_guestbook ;
RENAME TABLE dedeqiye_member_model TO dedeqiye0_member_model ;
RENAME TABLE dedeqiye_member_msg TO dedeqiye0_member_msg ;
RENAME TABLE dedeqiye_member_operation TO dedeqiye0_member_operation ;
RENAME TABLE dedeqiye_member_person TO dedeqiye0_member_person ;
RENAME TABLE dedeqiye_member_pms TO dedeqiye0_member_pms ;
RENAME TABLE dedeqiye_member_snsmsg TO dedeqiye0_member_snsmsg ;
RENAME TABLE dedeqiye_member_space TO dedeqiye0_member_space ;
RENAME TABLE dedeqiye_member_stow TO dedeqiye0_member_stow ;
RENAME TABLE dedeqiye_member_stowtype TO dedeqiye0_member_stowtype ;
RENAME TABLE dedeqiye_member_tj TO dedeqiye0_member_tj ;
RENAME TABLE dedeqiye_member_type TO dedeqiye0_member_type ;
RENAME TABLE dedeqiye_member_vhistory TO dedeqiye0_member_vhistory ;
RENAME TABLE dedeqiye_moneycard_record TO dedeqiye0_moneycard_record ;
RENAME TABLE dedeqiye_moneycard_type TO dedeqiye0_moneycard_type ;
RENAME TABLE dedeqiye_mtypes TO dedeqiye0_mtypes ;
RENAME TABLE dedeqiye_multiserv_config TO dedeqiye0_multiserv_config ;
RENAME TABLE dedeqiye_myad TO dedeqiye0_myad ;
RENAME TABLE dedeqiye_mytag TO dedeqiye0_mytag ;
RENAME TABLE dedeqiye_payment TO dedeqiye0_payment ;
RENAME TABLE dedeqiye_plus TO dedeqiye0_plus ;
RENAME TABLE dedeqiye_purview TO dedeqiye0_purview ;
RENAME TABLE dedeqiye_pwd_tmp TO dedeqiye0_pwd_tmp ;
RENAME TABLE dedeqiye_ratings TO dedeqiye0_ratings ;
RENAME TABLE dedeqiye_scores TO dedeqiye0_scores ;
RENAME TABLE dedeqiye_search_cache TO dedeqiye0_search_cache ;
RENAME TABLE dedeqiye_search_keywords TO dedeqiye0_search_keywords ;
RENAME TABLE dedeqiye_sgpage TO dedeqiye0_sgpage ;
RENAME TABLE dedeqiye_shops_delivery TO dedeqiye0_shops_delivery ;
RENAME TABLE dedeqiye_shops_orders TO dedeqiye0_shops_orders ;
RENAME TABLE dedeqiye_shops_products TO dedeqiye0_shops_products ;
RENAME TABLE dedeqiye_shops_userinfo TO dedeqiye0_shops_userinfo ;
RENAME TABLE dedeqiye_softconfig TO dedeqiye0_softconfig ;
RENAME TABLE dedeqiye_sphinx TO dedeqiye0_sphinx ;
RENAME TABLE dedeqiye_stepselect TO dedeqiye0_stepselect ;
RENAME TABLE dedeqiye_sys_enum TO dedeqiye0_sys_enum ;
RENAME TABLE dedeqiye_sys_module TO dedeqiye0_sys_module ;
RENAME TABLE dedeqiye_sys_set TO dedeqiye0_sys_set ;
RENAME TABLE dedeqiye_sys_task TO dedeqiye0_sys_task ;
RENAME TABLE dedeqiye_sysconfig TO dedeqiye0_sysconfig ;
RENAME TABLE dedeqiye_tagindex TO dedeqiye0_tagindex ;
RENAME TABLE dedeqiye_taglist TO dedeqiye0_taglist ;
RENAME TABLE dedeqiye_taoke_channel TO dedeqiye0_taoke_channel ;
RENAME TABLE dedeqiye_taoke_product TO dedeqiye0_taoke_product ;
RENAME TABLE dedeqiye_taoke_shop TO dedeqiye0_taoke_shop ;
RENAME TABLE dedeqiye_uploads TO dedeqiye0_uploads ;
RENAME TABLE dedeqiye_verifies TO dedeqiye0_verifies ;
RENAME TABLE dedeqiye_vote TO dedeqiye0_vote ;
RENAME TABLE dedeqiye_vote_member TO dedeqiye0_vote_member ;
使用sql命令方式，直接更改数据库表前缀。
注意：这个表格列表是在dede5.6utf版本中复制下来的。如果你使用的其他dede版本。请对照你的数据库列表修改
2、修改 dede_channeltype 表中的maintable 和addtable字段，对应修改为dede_test_的形式！
打开phpmyadmin,打开你的数据库，找到表 dede_channeltype，修改maintable 和addtable字段的内容，将数据库前缀改为dedeqiye0
3、最后修改/data/common.inc.php配置文件中的表前缀即可！
将相应的数据库前缀参数改为dedeqiye0
收工！
注意，以上的例子是将数据库前缀由dedeqiye改为dedeqiye0,您在操作时，需要把数据库前缀换成你自己的哦。