discuz提示(1146) Table '*.common_member_archive' doesn't exist的解决方法

admin

sql 语句执行：

1. CREATE TABLE pre_common_member_archive SELECT * FROM pre_common_member;
   
2. CREATE TABLE pre_common_member_profile_archive SELECT * FROM pre_common_member_profile;
   
3. CREATE TABLE pre_common_member_field_forum_archive SELECT * FROM pre_common_member_field_forum;
   
4. CREATE TABLE pre_common_member_status_archive SELECT * FROM pre_common_member_status;
   
5. CREATE TABLE pre_common_member_count_archive SELECT * FROM pre_common_member_count;

复制代码

注意表前缀改为自己的。
然后如果数据量太大的情况，可能执行时间太长会出一些小问题，数据量大的情况不建议此种方案。