织梦怎么批量修改表前缀(利用sql语句)

织梦建站 21NN 2年前 (2018-05-24) 7次浏览 已收录 0个评论 扫描二维码
安装DedeCMS的时候,数据表前缀默认为dede_,当系统使用了一段时间后,想更改数据表前缀,结果发现不是那么容易。有没有批量修改表前缀的方法?
在phpmyadmin执行如下SQL命令,将表前缀转换

修改好表前缀后,重启一下mysql,还需要修改/DATA/COMMON.INC.PHP文件中的$cfg_dbprefix = ‘dede_’。以及对后台中的“频道模型”–>“内容模型管理”中的相应的附加表shop_addonarticle也做一下修改。

ALTER TABLE dede_addonimages RENAME TO shop_addonimages;
ALTER TABLE dede_addoninfos RENAME TO shop_addoninfos;
ALTER TABLE dede_admin RENAME TO shop_admin;
ALTER TABLE dede_admintype RENAME TO shop_admintype;
ALTER TABLE dede_advancedsearch RENAME TO shop_advancedsearch;
ALTER TABLE dede_arcatt RENAME TO shop_arcatt;
ALTER TABLE dede_arccache RENAME TO shop_arccache;
ALTER TABLE dede_archives RENAME TO shop_archives;
ALTER TABLE dede_arcmulti RENAME TO shop_arcmulti;
ALTER TABLE dede_arcrank RENAME TO shop_arcrank;
ALTER TABLE dede_arctiny RENAME TO shop_arctiny;
ALTER TABLE dede_arctype RENAME TO shop_arctype;
ALTER TABLE dede_area RENAME TO shop_area;
ALTER TABLE dede_channeltype RENAME TO shop_channeltype;
ALTER TABLE dede_co_htmls RENAME TO shop_co_htmls;
ALTER TABLE dede_co_mediaurls RENAME TO shop_co_mediaurls;
ALTER TABLE dede_co_note RENAME TO shop_co_note;
ALTER TABLE dede_co_onepage RENAME TO shop_co_onepage;
ALTER TABLE dede_co_urls RENAME TO shop_co_urls;
ALTER TABLE dede_diyforms RENAME TO shop_diyforms;
ALTER TABLE dede_downloads RENAME TO shop_downloads;
ALTER TABLE dede_erradd RENAME TO shop_erradd;
ALTER TABLE dede_feedback RENAME TO shop_feedback;
ALTER TABLE dede_flink RENAME TO shop_flink;
ALTER TABLE dede_flinktype RENAME TO shop_flinktype;
ALTER TABLE dede_freelist RENAME TO shop_freelist;
ALTER TABLE dede_homepageset RENAME TO shop_homepageset;
ALTER TABLE dede_keywords RENAME TO shop_keywords;
ALTER TABLE dede_log RENAME TO shop_log;
ALTER TABLE dede_member RENAME TO shop_member;
ALTER TABLE dede_member_company RENAME TO shop_member_company;
ALTER TABLE dede_member_feed RENAME TO shop_member_feed;
ALTER TABLE dede_member_flink RENAME TO shop_member_flink;
ALTER TABLE dede_member_friends RENAME TO shop_member_friends;
ALTER TABLE dede_member_group RENAME TO shop_member_group;
ALTER TABLE dede_member_guestbook RENAME TO shop_member_guestbook;
ALTER TABLE dede_member_model RENAME TO shop_member_model;
ALTER TABLE dede_member_msg RENAME TO shop_member_msg;
ALTER TABLE dede_member_operation RENAME TO shop_member_operation;
ALTER TABLE dede_member_person RENAME TO shop_member_person;
ALTER TABLE dede_member_pms RENAME TO shop_member_pms;
ALTER TABLE dede_member_snsmsg RENAME TO shop_member_snsmsg;
ALTER TABLE dede_member_space RENAME TO shop_member_space;
ALTER TABLE dede_member_stow RENAME TO shop_member_stow;
ALTER TABLE dede_member_stowtype RENAME TO shop_member_stowtype;
ALTER TABLE dede_member_tj RENAME TO shop_member_tj;
ALTER TABLE dede_member_type RENAME TO shop_member_type;
ALTER TABLE dede_member_vhistory RENAME TO shop_member_vhistory;
ALTER TABLE dede_moneycard_record RENAME TO shop_moneycard_record;
ALTER TABLE dede_moneycard_type RENAME TO shop_moneycard_type;
ALTER TABLE dede_mtypes RENAME TO shop_mtypes;
ALTER TABLE dede_multiserv_config RENAME TO shop_multiserv_config;
ALTER TABLE dede_myad RENAME TO shop_myad;
ALTER TABLE dede_mytag RENAME TO shop_mytag;
ALTER TABLE dede_plus RENAME TO shop_plus;
ALTER TABLE dede_pwd_tmp RENAME TO shop_pwd_tmp;
ALTER TABLE dede_ratings RENAME TO shop_ratings;
ALTER TABLE dede_scores RENAME TO shop_scores;
ALTER TABLE dede_search_cache RENAME TO shop_search_cache;
ALTER TABLE dede_search_keywords RENAME TO shop_search_keywords;
ALTER TABLE dede_sgpage RENAME TO shop_sgpage;
ALTER TABLE dede_shops_delivery RENAME TO shop_shops_delivery;
ALTER TABLE dede_shops_orders RENAME TO shop_shops_orders;
ALTER TABLE dede_shops_products RENAME TO shop_shops_products;
ALTER TABLE dede_shops_userinfo RENAME TO shop_shops_userinfo;
ALTER TABLE dede_softconfig RENAME TO shop_softconfig;
ALTER TABLE dede_stepselect RENAME TO shop_stepselect;
ALTER TABLE dede_sys_enum RENAME TO shop_sys_enum;
ALTER TABLE dede_sys_module RENAME TO shop_sys_module;
ALTER TABLE dede_sys_set RENAME TO shop_sys_set;
ALTER TABLE dede_sys_task RENAME TO shop_sys_task;
ALTER TABLE dede_sysconfig RENAME TO shop_sysconfig;
ALTER TABLE dede_tagindex RENAME TO shop_tagindex;
ALTER TABLE dede_taglist RENAME TO shop_taglist;
ALTER TABLE dede_uploads RENAME TO shop_uploads;
ALTER TABLE dede_verifies RENAME TO shop_verifies;
ALTER TABLE dede_vote RENAME TO shop_vote;
ALTER TABLE dede_addonarticle RENAME TO shop_addonarticle; 


本文:织梦怎么批量修改表前缀(利用sql语句) 本文链接:https://www.21nn.cn/jianzhan/dedecmsjianzhan/17030.html 本站所以图片、文章仅限用于学习和研究目的; 不得将上述内容用于商业或者非法用途,否则,一切后果请用户自负。 本站信息来自网络,版权争议与本站无关。 您必须在下载后的24个小时之内,从您的电脑中彻底删除上述内容。 如有侵权请邮件与我们联系处理。i@ki4.cn
喜欢 (0)
[1353713598@qq.com]
分享 (0)
发表我的评论
取消评论
表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址