discuz x 论坛单独备份注册会员数据的数据表
- pre_common_member会员主表：用户名、密码 hash、邮箱、注册时间、用户组、冻结状态、loginname(X5 新增登录唯一标识)
- pre_common_member_count会员统计：积分、扩展积分、发帖数、回帖数
- pre_common_member_profile个人资料：性别、生日、手机、联系地址等扩展资料
- pre_common_member_field_forum论坛相关会员数据：勋章、发帖签名、隐身设置等
- pre_common_member_field_home个人空间相关：空间签名、相册设置等
✅【建议一并备份，保证会员功能完整】
- pre_common_member_security安全相关：密保、问题、登录保护记录
- pre_common_member_validate邮箱、手机验证记录
- pre_common_member_accountX5 新增，第三方登录绑定（QQ / 微信等互联账号）
- pre_common_member_username_historyX5 新增，用户名改名历史记录
- pre_common_credit_log积分变动日志
✅【配套，用户组权限，恢复会员后权限正常】
- pre_common_usergroup用户组基础
- pre_common_usergroup_field用户组权限详细配置
mysqldump 命令（服务器 SSH 执行，导出会员表）
替换：数据库名、数据库用户、pre_为你真实表前缀；输出保存到/home/backup/member.sql
mysqldump -u数据库用户 -p 数据库名 \ pre_common_member \ pre_common_member_count \ pre_common_member_profile \ pre_common_member_field_forum \ pre_common_member_field_home \ pre_common_member_security \ pre_common_member_validate \ pre_common_member_account \ pre_common_member_username_history \ pre_common_credit_log \ pre_common_usergroup \ pre_common_usergroup_field \ > /home/backup/member.sql
执行后会提示输入数据库密码。
或者使用PHPMYADMIN登录后，运行SQL。
sql
CREATE TABLE a_bak_pre_common_member LIKE pre_common_member;
INSERT INTO a_bak_pre_common_member SELECT * FROM pre_common_member;
CREATE TABLE a_bak_pre_common_member_count LIKE pre_common_member_count;
INSERT INTO a_bak_pre_common_member_count SELECT * FROM pre_common_member_count;
CREATE TABLE a_bak_pre_common_member_profile LIKE pre_common_maember_profile;
INSERT INTO a_bak_pre_common_member_profile SELECT * FROM pre_common_member_profile;
CREATE TABLE a_bak_pre_common_member_field_forum LIKE pre_common_member_field_forum;
INSERT INTO a_bak_pre_common_member_field_forum SELECT * FROM pre_common_member_field_forum;
CREATE TABLE a_bak_pre_common_member_field_home LIKE pre_common_member_field_home;
INSERT INTO a_bak_pre_common_member_field_home SELECT * FROM pre_common_member_field_home;
CREATE TABLE a_bak_pre_common_member_security LIKE pre_common_member_security;
INSERT INTO a_bak_pre_common_member_security SELECT * FROM pre_common_member_security;
CREATE TABLE a_bak_pre_common_member_validate LIKE pre_common_member_validate;
INSERT INTO a_bak_pre_common_member_validate SELECT * FROM pre_common_member_validate;
CREATE TABLE a_bak_pre_common_member_account LIKE pre_common_member_account;
INSERT INTO a_bak_pre_common_member_account SELECT * FROM pre_common_member_account;
CREATE TABLE a_bak_pre_common_member_username_history LIKE pre_common_member_username_history;
INSERT INTO a_bak_pre_common_member_username_history SELECT * FROM pre_common_member_username_history;
CREATE TABLE a_bak_pre_common_credit_log LIKE pre_common_credit_log;
INSERT INTO a_bak_pre_common_credit_log SELECT * FROM pre_common_credit_log;
CREATE TABLE a_bak_pre_common_usergroup LIKE pre_common_usergroup;
INSERT INTO a_bak_pre_common_usergroup SELECT * FROM pre_common_usergroup;
CREATE TABLE a_bak_pre_common_usergroup_field LIKE pre_common_usergroup_field;
INSERT INTO a_bak_pre_common_usergroup_field SELECT * FROM pre_common_usergroup_field;
然后在PHPMYADMIN的界面浏览数据库，点击导出这几个表。恢复数据前用编辑器打开下载的SQL文件，批量替换a_bak_为空，保存后，恢复导入即可。
