问个数据表转换的问题～

已经安装好，有数据的论坛，怎样把数据表中的前缀cdb_变为cdb2_呢？

备份原论坛,新建一个 cdb2_的论坛,导入.

原帖由 asdf1999 于 2006-7-5 17:57 发表备份原论坛,新建一个 cdb2_的论坛,导入.

这样是不行的
执行下面的 SQL 语句即可：

ALTER TABLE cdb_adminnotes RENAME cdb2_adminnotes;
ALTER TABLE cdb_adminsessions RENAME cdb2_adminsessions;
ALTER TABLE cdb_advertisements RENAME cdb2_advertisements;
ALTER TABLE cdb_announcements RENAME cdb2_announcements;
ALTER TABLE cdb_attachments RENAME cdb2_attachments;
ALTER TABLE cdb_attachtypes RENAME cdb2_attachtypes;
ALTER TABLE cdb_banned RENAME cdb2_banned;
ALTER TABLE cdb_bbcodes RENAME cdb2_bbcodes;
ALTER TABLE cdb_blogcaches RENAME cdb2_blogcaches;
ALTER TABLE cdb_buddys RENAME cdb2_buddys;
ALTER TABLE cdb_creditslog RENAME cdb2_creditslog;
ALTER TABLE cdb_failedlogins RENAME cdb2_failedlogins;
ALTER TABLE cdb_favorites RENAME cdb2_favorites;
ALTER TABLE cdb_forumfields RENAME cdb2_forumfields;
ALTER TABLE cdb_forumlinks RENAME cdb2_forumlinks;
ALTER TABLE cdb_forums RENAME cdb2_forums;
ALTER TABLE cdb_medals RENAME cdb2_medals;
ALTER TABLE cdb_memberfields RENAME cdb2_memberfields;
ALTER TABLE cdb_members RENAME cdb2_members;
ALTER TABLE cdb_moderators RENAME cdb2_moderators;
ALTER TABLE cdb_onlinelist RENAME cdb2_onlinelist;
ALTER TABLE cdb_onlinetime RENAME cdb2_onlinetime;
ALTER TABLE cdb_orders RENAME cdb2_orders;
ALTER TABLE cdb_paymentlog RENAME cdb2_paymentlog;
ALTER TABLE cdb_plugins RENAME cdb2_plugins;
ALTER TABLE cdb_pluginvars RENAME cdb2_pluginvars;
ALTER TABLE cdb_pms RENAME cdb2_pms;
ALTER TABLE cdb_polls RENAME cdb2_polls;
ALTER TABLE cdb_posts RENAME cdb2_posts;
ALTER TABLE cdb_profilefields RENAME cdb2_profilefields;
ALTER TABLE cdb_ranks RENAME cdb2_ranks;
ALTER TABLE cdb_ratelog RENAME cdb2_ratelog;
ALTER TABLE cdb_regips RENAME cdb2_regips;
ALTER TABLE cdb_rsscaches RENAME cdb2_rsscaches;
ALTER TABLE cdb_searchindex RENAME cdb2_searchindex;
ALTER TABLE cdb_sessions RENAME cdb2_sessions;
ALTER TABLE cdb_settings RENAME cdb2_settings;
ALTER TABLE cdb_smilies RENAME cdb2_smilies;
ALTER TABLE cdb_stats RENAME cdb2_stats;
ALTER TABLE cdb_statvars RENAME cdb2_statvars;
ALTER TABLE cdb_styles RENAME cdb2_styles;
ALTER TABLE cdb_stylevars RENAME cdb2_stylevars;
ALTER TABLE cdb_subscriptions RENAME cdb2_subscriptions;
ALTER TABLE cdb_templates RENAME cdb2_templates;
ALTER TABLE cdb_threads RENAME cdb2_threads;
ALTER TABLE cdb_threadsmod RENAME cdb2_threadsmod;
ALTER TABLE cdb_threadtypes RENAME cdb2_threadtypes;
ALTER TABLE cdb_usergroups RENAME cdb2_usergroups;
ALTER TABLE cdb_validating RENAME cdb2_validating;
ALTER TABLE cdb_words RENAME cdb2_words;

仅适用于没有增加数据表的 Discuz! 4.X