{"id":9390,"date":"2026-08-20T10:03:18","date_gmt":"2026-08-20T02:03:18","guid":{"rendered":"https:\/\/rjzb.com\/wp\/?p=9390"},"modified":"2026-08-20T15:50:55","modified_gmt":"2026-08-20T07:50:55","slug":"discuz-x-%e8%ae%ba%e5%9d%9b%e5%8d%95%e7%8b%ac%e5%a4%87%e4%bb%bd%e6%b3%a8%e5%86%8c%e4%bc%9a%e5%91%98%e6%95%b0%e6%8d%ae%e7%9a%84%e6%95%b0%e6%8d%ae%e8%a1%a8","status":"publish","type":"post","link":"https:\/\/rjzb.com\/wp\/?p=9390","title":{"rendered":"discuz x \u8bba\u575b\u5355\u72ec\u5907\u4efd\u6ce8\u518c\u4f1a\u5458\u6570\u636e\u7684\u6570\u636e\u8868"},"content":{"rendered":"
\n
    \n
  1. \n\t\t\tpre_common_member\u4f1a\u5458\u4e3b\u8868\uff1a\u7528\u6237\u540d\u3001\u5bc6\u7801 hash\u3001\u90ae\u7bb1\u3001\u6ce8\u518c\u65f6\u95f4\u3001\u7528\u6237\u7ec4\u3001\u51bb\u7ed3\u72b6\u6001\u3001loginname(X5 \u65b0\u589e\u767b\u5f55\u552f\u4e00\u6807\u8bc6)\n\t\t<\/li>\n
  2. \n\t\t\tpre_common_member_count\u4f1a\u5458\u7edf\u8ba1\uff1a\u79ef\u5206\u3001\u6269\u5c55\u79ef\u5206\u3001\u53d1\u5e16\u6570\u3001\u56de\u5e16\u6570\n\t\t<\/li>\n
  3. \n\t\t\tpre_common_member_profile\u4e2a\u4eba\u8d44\u6599\uff1a\u6027\u522b\u3001\u751f\u65e5\u3001\u624b\u673a\u3001\u8054\u7cfb\u5730\u5740\u7b49\u6269\u5c55\u8d44\u6599\n\t\t<\/li>\n
  4. \n\t\t\tpre_common_member_field_forum\u8bba\u575b\u76f8\u5173\u4f1a\u5458\u6570\u636e\uff1a\u52cb\u7ae0\u3001\u53d1\u5e16\u7b7e\u540d\u3001\u9690\u8eab\u8bbe\u7f6e\u7b49\n\t\t<\/li>\n
  5. \n\t\t\tpre_common_member_field_home\u4e2a\u4eba\u7a7a\u95f4\u76f8\u5173\uff1a\u7a7a\u95f4\u7b7e\u540d\u3001\u76f8\u518c\u8bbe\u7f6e\u7b49\n\t\t<\/li>\n<\/ol>\n<\/div>\n
    \n

    \n\t\t✅\u3010\u5efa\u8bae\u4e00\u5e76\u5907\u4efd\uff0c\u4fdd\u8bc1\u4f1a\u5458\u529f\u80fd\u5b8c\u6574\u3011
    \n\t<\/h2>\n<\/div>\n
    \n
      \n
    1. \n\t\t\tpre_common_member_security\u5b89\u5168\u76f8\u5173\uff1a\u5bc6\u4fdd\u3001\u95ee\u9898\u3001\u767b\u5f55\u4fdd\u62a4\u8bb0\u5f55\n\t\t<\/li>\n
    2. \n\t\t\tpre_common_member_validate\u90ae\u7bb1\u3001\u624b\u673a\u9a8c\u8bc1\u8bb0\u5f55\n\t\t<\/li>\n
    3. \n\t\t\tpre_common_member_accountX5 \u65b0\u589e\uff0c\u7b2c\u4e09\u65b9\u767b\u5f55\u7ed1\u5b9a\uff08QQ \/ \u5fae\u4fe1\u7b49\u4e92\u8054\u8d26\u53f7\uff09\n\t\t<\/li>\n
    4. \n\t\t\tpre_common_member_username_historyX5 \u65b0\u589e\uff0c\u7528\u6237\u540d\u6539\u540d\u5386\u53f2\u8bb0\u5f55\n\t\t<\/li>\n
    5. \n\t\t\tpre_common_credit_log\u79ef\u5206\u53d8\u52a8\u65e5\u5fd7\n\t\t<\/li>\n<\/ol>\n<\/div>\n
      \n

      \n\t\t✅\u3010\u914d\u5957\uff0c\u7528\u6237\u7ec4\u6743\u9650\uff0c\u6062\u590d\u4f1a\u5458\u540e\u6743\u9650\u6b63\u5e38\u3011
      \n\t<\/h2>\n<\/div>\n

      \n\t\n<\/p>\n

        \n
      • \n\t\tpre_common_usergroup\u7528\u6237\u7ec4\u57fa\u7840\n\t<\/li>\n<\/ul>\n

        \n\t\n<\/p>\n

          \n
        • \n\t\tpre_common_usergroup_field\u7528\u6237\u7ec4\u6743\u9650\u8be6\u7ec6\u914d\u7f6e\n\t<\/li>\n<\/ul>\n

          \n\t\n<\/p>\n

          \n

          \n\t\tmysqldump \u547d\u4ee4\uff08\u670d\u52a1\u5668 SSH \u6267\u884c\uff0c\u5bfc\u51fa\u4f1a\u5458\u8868\uff09
          \n\t<\/h1>\n<\/div>\n
          \n
          \n
          \n
          \n\t\t\t\t\u66ff\u6362\uff1a\u6570\u636e\u5e93\u540d\u3001\u6570\u636e\u5e93\u7528\u6237\u3001pre_\u4e3a\u4f60\u771f\u5b9e\u8868\u524d\u7f00\uff1b\u8f93\u51fa\u4fdd\u5b58\u5230\/home\/backup\/member.sql\n\t\t\t<\/div>\n<\/p><\/div>\n<\/blockquote>\n<\/div>\n
          \n
          \n
          \n
          \n
          \n
          \n
          \n\t\t\t\t\t\t\tbash\n\t\t\t\t\t\t<\/div>\n
          \n\t\t\t\t\t\t<\/div>\n<\/p><\/div>\n
          \n
          \n\t\t\t\t\t\t<\/div>\n
          \n\t\t\t\t\t\t<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
          \n
          mysqldump -u\u6570\u636e\u5e93\u7528\u6237 -p<\/span> \u6570\u636e\u5e93\u540d \\<\/span> pre_common_member \\<\/span> pre_common_member_count \\<\/span> pre_common_member_profile \\<\/span> pre_common_member_field_forum \\<\/span> pre_common_member_field_home \\<\/span> pre_common_member_security \\<\/span> pre_common_member_validate \\<\/span> pre_common_member_account \\<\/span> pre_common_member_username_history \\<\/span> pre_common_credit_log \\<\/span> pre_common_usergroup \\<\/span> pre_common_usergroup_field \\<\/span> ><\/span> \/home\/backup\/member.sql<\/pre>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n
          \n\t\n<\/p>\n
          \n\t\n<\/p>\n
          \n\t\u6267\u884c\u540e\u4f1a\u63d0\u793a\u8f93\u5165\u6570\u636e\u5e93\u5bc6\u7801\u3002\n<\/p>\n
          \n\t\n<\/p>\n
          \n\t\u6216\u8005\u4f7f\u7528PHPMYADMIN\u767b\u5f55\u540e\uff0c\u8fd0\u884cSQL\u3002\n<\/p>\n
          \n\t\n<\/p>\n
          \n
          \n\t\tphpMyAdmin\u2011SQL \u6267\u884c\u6846\u6267\u884c\uff0c\u4f1a\u5728\u5f53\u524d\u5e93\u751f\u6210\u5e26_bak\u540e\u7f00\u5907\u4efd\u526f\u672c\uff0c\u539f\u5730\u5907\u4efd\uff1a\n\t<\/div>\n<\/div>\n
          \n
          \n
          \n
          \n
          \n
          \n
          \n\t\t\t\t\t\t\tphpMyAdmin\u2011SQL \u6267\u884c\u6846\u6267\u884c\uff0c\u4f1a\u5728\u5f53\u524d\u5e93\u751f\u6210\u5e26  \u540e\u7f00\u5907\u4efd\u526f\u672c\uff0c\u539f\u5730\u5907\u4efd\uff1a
          \nsql
          \nCREATE TABLE a_bak_pre_common_member LIKE pre_common_member;
          \nINSERT INTO a_bak_pre_common_member SELECT * FROM pre_common_member;<\/p>\n
          CREATE TABLE a_bak_pre_common_member_count LIKE pre_common_member_count;
          \nINSERT INTO a_bak_pre_common_member_count SELECT * FROM pre_common_member_count;<\/p>\n
          CREATE TABLE a_bak_pre_common_member_profile LIKE pre_common_maember_profile;
          \nINSERT INTO a_bak_pre_common_member_profile SELECT * FROM pre_common_member_profile;<\/p>\n
          CREATE TABLE a_bak_pre_common_member_field_forum LIKE pre_common_member_field_forum;
          \nINSERT INTO a_bak_pre_common_member_field_forum SELECT * FROM pre_common_member_field_forum;<\/p>\n
          CREATE TABLE a_bak_pre_common_member_field_home LIKE pre_common_member_field_home;
          \nINSERT INTO a_bak_pre_common_member_field_home SELECT * FROM pre_common_member_field_home;<\/p>\n
          CREATE TABLE a_bak_pre_common_member_security LIKE pre_common_member_security;
          \nINSERT INTO a_bak_pre_common_member_security SELECT * FROM pre_common_member_security;<\/p>\n
          CREATE TABLE a_bak_pre_common_member_validate LIKE pre_common_member_validate;
          \nINSERT INTO a_bak_pre_common_member_validate SELECT * FROM pre_common_member_validate;<\/p>\n
          CREATE TABLE a_bak_pre_common_member_account LIKE pre_common_member_account;
          \nINSERT INTO a_bak_pre_common_member_account SELECT * FROM pre_common_member_account;<\/p>\n
          CREATE TABLE a_bak_pre_common_member_username_history LIKE pre_common_member_username_history;
          \nINSERT INTO a_bak_pre_common_member_username_history SELECT * FROM pre_common_member_username_history;<\/p>\n
          CREATE TABLE a_bak_pre_common_credit_log LIKE pre_common_credit_log;
          \nINSERT INTO a_bak_pre_common_credit_log SELECT * FROM pre_common_credit_log;<\/p>\n
          CREATE TABLE a_bak_pre_common_usergroup LIKE pre_common_usergroup;
          \nINSERT INTO a_bak_pre_common_usergroup SELECT * FROM pre_common_usergroup;<\/p>\n
          CREATE TABLE a_bak_pre_common_usergroup_field LIKE pre_common_usergroup_field;
          \nINSERT INTO a_bak_pre_common_usergroup_field SELECT * FROM pre_common_usergroup_field;<\/p>\n
          \n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n
          \u7136\u540e\u5728PHPMYADMIN\u7684\u754c\u9762\u6d4f\u89c8\u6570\u636e\u5e93\uff0c\u70b9\u51fb\u5bfc\u51fa\u8fd9\u51e0\u4e2a\u8868\u3002\u6062\u590d\u6570\u636e\u524d\u7528\u7f16\u8f91\u5668\u6253\u5f00\u4e0b\u8f7d\u7684SQL\u6587\u4ef6\uff0c\u6279\u91cf\u66ff\u6362a_bak_\u4e3a\u7a7a\uff0c\u4fdd\u5b58\u540e\uff0c\u6062\u590d\u5bfc\u5165\u5373\u53ef\u3002<\/span><\/p>\n
          \n\t<\/p>\n","protected":false},"excerpt":{"rendered":"
          pre_common_member\u4f1a\u5458\u4e3b\u8868\uff1a\u7528\u6237\u540d\u3001\u5bc6\u7801 hash\u3001\u90ae\u7bb1\u3001\u6ce8\u518c\u65f6\u95f4\u3001\u7528\u6237\u7ec4\u3001\u51bb\u7ed3\u72b6\u6001\u3001logi […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-9390","post","type-post","status-publish","format-standard","hentry","category-safe"],"views":9,"_links":{"self":[{"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/9390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9390"}],"version-history":[{"count":3,"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/9390\/revisions"}],"predecessor-version":[{"id":9393,"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/9390\/revisions\/9393"}],"wp:attachment":[{"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rjzb.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}