织梦数据库前缀替换步骤是怎样的?

99ANYc3cd6
预计阅读时长 88 分钟
位置: 首页 织梦建站 正文

⚠️ 重要提醒:操作前必读

  1. 备份!备份!备份! 这是最重要的一步,在进行任何数据库操作之前,请务必备份你的整个网站文件和数据库,如果操作失误,备份是你唯一的恢复手段。
  2. 理解前缀:数据库前缀是用于区分不同网站数据的一串字符,默认是 dede_,文章表是 dede_archives,会员表是 dede_member
  3. 操作权限:你需要拥有网站服务器的文件管理权限(如通过FTP或SSH)和数据库管理权限(如通过phpMyAdmin)。

操作步骤

我们将整个过程分为三个主要部分:

织梦替换数据库前缀
(图片来源网络,侵删)
  1. 第一步:修改数据库表
  2. 第二步:修改系统配置文件
  3. 第三步:验证和清理

第一步:修改数据库表名

这一步的目标是将所有 旧前缀dede_)的表名修改为 新前缀new_)。

使用phpMyAdmin(推荐,最直观)

  1. 登录phpMyAdmin

    • 登录你的网站控制面板(如cPanel、Plesk等),找到phpMyAdmin工具。
    • 选择你的织梦网站所使用的数据库。
  2. 执行SQL语句

    • 在phpMyAdmin的顶部菜单栏,点击 “SQL” 选项卡,进入SQL查询界面。
    • 在下方的文本框中,粘贴以下SQL语句。请务必将 旧前缀新前缀 替换成你自己的值。
    -- 将所有以 '旧前缀' 开头的表名,替换为 '新前缀'
    RENAME TABLE `旧前缀_arctype` TO `新前缀_arctype`;
    RENAME TABLE `旧前缀_archives` TO `新前缀_archives`;
    RENAME TABLE `旧前缀_addonarticle` TO `新前缀_addonarticle`;
    RENAME TABLE `旧前缀_channeltype` TO `新前缀_channeltype`;
    RENAME TABLE `旧前缀_co_htmlsource` TO `新前缀_co_htmlsource`;
    RENAME TABLE `旧前缀_co_note` TO `新前缀_co_note`;
    RENAME TABLE `旧前缀_config` TO `新前缀_config`;
    RENAME TABLE `旧前缀_diagnosis` TO `新前缀_diagnosis`;
    RENAME TABLE `旧前缀_downloads` TO `新前缀_downloads`;
    RENAME TABLE `旧前缀_enumlist` TO `新前缀_enumlist`;
    RENAME TABLE `旧前缀_feedback` TO `新前缀_feedback`;
    RENAME TABLE `旧前缀_homepageset` TO `新前缀_homepageset`;
    RENAME TABLE `旧前缀_keywords` TO `新前缀_keywords`;
    RENAME TABLE `旧前缀_log` TO `新前缀_log`;
    RENAME TABLE `旧前缀_member` TO `新前缀_member`;
    RENAME TABLE `旧前缀_member_stow` TO `新前缀_member_stow`;
    RENAME TABLE `旧前缀_member_tplist` TO `新前缀_member_tplist`;
    RENAME TABLE `旧前缀_member_space` TO `新前缀_member_space`;
    RENAME TABLE `旧前缀_member_weblink` TO `新前缀_member_weblink`;
    RENAME TABLE `旧前缀_news` TO `新前缀_news`;
    RENAME TABLE `旧前_prefix_pagetitle` TO `新前缀_pagetitle`;
    RENAME TABLE `旧前缀_pay ranks` TO `新前缀_pay ranks`;
    RENAME TABLE `旧前_prefix_plans` TO `新前缀_plans`;
    RENAME TABLE `旧前_prefix_plus` TO `新前缀_plus`;
    RENAME TABLE `旧前_prefix_portal` TO `新前缀_portal`;
    RENAME TABLE `旧前_prefix_portalcategory` TO `新前缀_portalcategory`;
    RENAME TABLE `旧前_prefix_pricearea` TO `新前缀_pricearea`;
    RENAME TABLE `旧前_prefix_shops` TO `新前缀_shops`;
    RENAME TABLE `旧前_prefix_shopex` TO `新前缀_shopex`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex_area` TO `新前缀_shopex_area`;
    RENAME TABLE `旧前_prefix_shopex_config` TO `新前缀_shopex_config`;
    RENAME TABLE `旧前_prefix_shopex_goods` TO `新前缀_shopex_goods`;
    RENAME TABLE `旧前_prefix_shopex_goods_type` TO `新前缀_shopex_goods_type`;
    RENAME TABLE `旧前_prefix_shopex_goods_attr` TO `新前缀_shopex_goods_attr`;
    RENAME TABLE `旧前_prefix_shopex_goods_gallery` TO `新前缀_shopex_goods_gallery`;
    RENAME TABLE `旧前_prefix_shopex_goods_count` TO `新前缀_shopex_goods_count`;
    RENAME TABLE `旧前_prefix_shopex_goods_brand` TO `新前缀_shopex_goods_brand`;
    RENAME TABLE `旧前_prefix_shopex_goods_cats` TO `新前缀_shopex_goods_cats`;
    RENAME TABLE `旧前_prefix_shopex_order` TO `新前缀_shopex_order`;
    RENAME TABLE `旧前_prefix_shopex_order_goods` TO `新前缀_shopex_order_goods`;
    RENAME TABLE `旧前_prefix_shopex_payment` TO `新前缀_shopex_payment`;
    RENAME TABLE `旧前_prefix_shopex_shipping` TO `新前缀_shopex_shipping`;
    RENAME TABLE `旧前_prefix_shopex
织梦替换数据库前缀
(图片来源网络,侵删)
-- 展开阅读全文 --
头像
织梦论坛源码下载站
« 上一篇 04-22
dede会员模块教程,如何快速搭建与配置?
下一篇 » 04-22

相关文章

取消
微信二维码
支付宝二维码

目录[+]