搜索
织梦建站

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

99ANYc3cd6
99ANYc3cd6 / / 0 评论 / 7 阅读
作者有点忙，还没来得及写简介......
预计阅读时长 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

相关文章

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

目录[+]