如何让Discuz X3.4用户表的主表和存档表的数据合并

操作前先要备份网站数据库

后台，站长，数据库，升级

insert into pre_common_member select * from pre_common_member_archive;
insert into pre_common_member_count select * from pre_common_member_count_archive;
insert into pre_common_member_field_forum select * from pre_common_member_field_forum_archive;
insert into pre_common_member_field_home select * from pre_common_member_field_home_archive;
insert into pre_common_member_profile select * from pre_common_member_profile_archive;
insert into pre_common_member_status select * from pre_common_member_status_archive;

以上六条的意思就是把六个存档表中的东西合并到主表中。

然后再使用如下升级数据库：

TRUNCATE TABLE  `pre_common_member_archive`;
TRUNCATE TABLE  `pre_common_member_count_archive`;
TRUNCATE TABLE  `pre_common_member_field_forum_archive`;
TRUNCATE TABLE  `pre_common_member_field_home_archive`;
TRUNCATE TABLE  `pre_common_member_profile_archive`;
TRUNCATE TABLE  `pre_common_member_status_archive`;

以上六条的意思就是把六个存档表数据全部清空。