{"id":553,"date":"2026-02-09T14:07:44","date_gmt":"2026-02-09T06:07:44","guid":{"rendered":"http:\/\/47.100.165.17\/wordpress\/?p=553"},"modified":"2026-03-02T22:57:12","modified_gmt":"2026-03-02T14:57:12","slug":"%e3%80%90mysql%e3%80%91%e5%a4%87%e4%bb%bd%e7%a5%9e%e5%99%a8-mydumper%ef%bc%9a%e5%8e%9f%e7%90%86%e3%80%81%e5%ae%9e%e6%93%8d%e4%b8%8e%e6%81%a2%e5%a4%8d%e5%85%a8%e6%8c%87%e5%8d%97","status":"publish","type":"post","link":"https:\/\/yunyanglib.cn\/?p=553","title":{"rendered":"\u3010MySQL\u3011\u5907\u4efd\u795e\u5668 mydumper\uff1a\u539f\u7406\u3001\u5b9e\u64cd\u4e0e\u6062\u590d\u5168\u6307\u5357"},"content":{"rendered":"\n

\u5728 MySQL \u6570\u636e\u5e93\u8fd0\u7ef4\u4e2d\uff0c\u5907\u4efd\u662f\u6570\u636e\u5b89\u5168\u7684\u6838\u5fc3\u4fdd\u969c\u3002\u76f8\u8f83\u4e8e\u4f20\u7edf\u7684 mysqldump\uff0cmydumper \u51ed\u501f\u591a\u7ebf\u7a0b\u5e76\u53d1\u3001\u6587\u4ef6\u6613\u7ba1\u7406\u3001\u6570\u636e\u4e00\u81f4\u6027\u5f3a\u7b49\u4f18\u52bf\uff0c\u6210\u4e3a\u4e2d\u5927\u578b\u6570\u636e\u5e93\u5907\u4efd\u7684\u4f18\u9009\u5de5\u5177\u3002\u672c\u6587\u5c06\u4ece\u6838\u5fc3\u7279\u70b9\u3001\u5b89\u88c5\u914d\u7f6e\u3001\u5907\u4efd \/ \u6062\u590d\u5b9e\u6218\u3001\u539f\u7406\u5256\u6790\u56db\u4e2a\u7ef4\u5ea6\uff0c\u5e26\u4f60\u5168\u9762\u638c\u63e1 mydumper \u7684\u4f7f\u7528\u6280\u5de7\u3002<\/p>\n\n\n\n

\u4e00\u3001mydumper \u6838\u5fc3\u4f18\u52bf<\/h2>\n\n\n\n

mydumper \u4e4b\u6240\u4ee5\u6210\u4e3a\u8fd0\u7ef4\u4eba\u5458\u7684 \u201c\u5fc3\u5934\u597d\u201d\uff0c\u6838\u5fc3\u5728\u4e8e\u4e09\u5927\u7279\u6027\uff1a<\/p>\n\n\n\n

    \n
  1. \u591a\u7ebf\u7a0b\u5e76\u53d1\u5907\u4efd<\/strong>\uff1a\u591a\u7ebf\u7a0b\u5e76\u884c\u5904\u7406\u4e0d\u540c\u6570\u636e\u8868\uff0c\u5907\u4efd\u901f\u5ea6\u8f83\u5355\u7ebf\u7a0b\u5de5\u5177\u63d0\u5347\u6570\u500d\uff0c\u9002\u914d\u6d77\u91cf\u8868\u573a\u666f\uff1b<\/li>\n\n\n\n
  2. \u6587\u4ef6\u7ed3\u6784\u6e05\u6670<\/strong>\uff1a\u8868\u7ed3\u6784\uff08.sql\uff09\u4e0e\u6570\u636e\u6587\u4ef6\u5206\u79bb\u5b58\u50a8\uff0c\u652f\u6301\u5355\u8868\u5feb\u901f\u6062\u590d\uff0c\u65e0\u9700\u89e3\u6790\u5b8c\u6574\u5907\u4efd\u5305\uff1b<\/li>\n\n\n\n
  3. \u4e00\u81f4\u6027\u4fdd\u969c<\/strong>\uff1a\n
      \n
    • InnoDB \u5f15\u64ce\uff1a\u901a\u8fc7\u4e8b\u52a1\u5feb\u7167\uff08REPEATABLE READ \u9694\u79bb\u7ea7\u522b\uff09\u786e\u4fdd\u6570\u636e\u4e00\u81f4\u6027\uff1b<\/li>\n\n\n\n
    • MyISAM \u5f15\u64ce\uff1a\u901a\u8fc7\u5168\u5c40\u8bfb\u9501\uff08FTWRL\uff09\u907f\u514d\u5907\u4efd\u8fc7\u7a0b\u4e2d\u6570\u636e\u5199\u5165\u51b2\u7a81\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n

      \u4e8c\u3001\u5b89\u88c5\u4e0e\u73af\u5883\u51c6\u5907<\/h2>\n\n\n\n

      2.1 \u5b89\u88c5 mydumper\uff08CentOS 7\uff09<\/h3>\n\n\n\n
      # 1. \u4e0b\u8f7d RPM \u5305\uff08v0.14.5-2 \u7a33\u5b9a\u7248\uff09\ncd \/usr\/src\/\nwget https:\/\/github.com\/mydumper\/mydumper\/releases\/download\/v0.14.5-2\/mydumper-0.14.5-2.el7.x86_64.rpm\n\n# 2.  yum \u5b89\u88c5\uff08\u81ea\u52a8\u89e3\u51b3\u4f9d\u8d56\uff09\nyum install mydumper-0.14.5-2.el7.x86_64.rpm -y\n\n# 3. \u9a8c\u8bc1\u5b89\u88c5\nmydumper --help  # \u663e\u793a\u5e2e\u52a9\u4fe1\u606f\u5373\u5b89\u88c5\u6210\u529f<\/code><\/pre>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      2.2 \u73af\u5883\u914d\u7f6e\uff08\u5fc5\u505a\u6b65\u9aa4\uff09<\/h3>\n\n\n\n
      2.2.1 \u521b\u5efa\u5907\u4efd\u4e13\u7528\u7528\u6237<\/h4>\n\n\n\n
      \u907f\u514d root \u8d26\u53f7\u76f4\u63a5\u64cd\u4f5c\uff0c\u521b\u5efa\u6700\u5c0f\u6743\u9650\u5907\u4efd\u7528\u6237\uff1a<\/p>\n\n\n\n
      -- \u521b\u5efa\u7528\u6237\uff08\u7528\u6237\u540d\uff1au_mydumper\uff0c\u5bc6\u7801\uff1aUd8agc_a\uff09\ncreate user u_mydumper@'%' identified WITH mysql_native_password BY 'Ud8agc_a';\n\n-- \u6388\u4e88\u5907\u4efd\u5fc5\u9700\u6743\u9650\ngrant create,insert,select,reload,process,lock tables,replication client,replication_slave_admin,show view,trigger,backup_admin on *.* to 'u_mydumper'@'%';<\/code><\/pre>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      2.2.2 \u914d\u7f6e\u5907\u4efd\u76ee\u5f55<\/h4>\n\n\n\n
      # \u521b\u5efa\u4e13\u7528\u5907\u4efd\u76ee\u5f55\uff08\u793a\u4f8b\u8def\u5f84\uff09\nmkdir -p \/data\/backup\/mydumper_bak\ncd \/data\/backup\/mydumper_bak<\/code><\/pre>\n\n\n\n
      2.2.3 \u5f00\u542f General Log\uff08\u53ef\u9009\uff0c\u7528\u4e8e\u95ee\u9898\u6392\u67e5\uff09<\/h4>\n\n\n\n
      -- \u5f00\u542f\u5168\u5c40\u65e5\u5fd7\nset global general_log=on;\n\n-- \u67e5\u770b\u65e5\u5fd7\u5b58\u50a8\u8def\u5f84\uff08\u9ed8\u8ba4\uff1a\/var\/lib\/mysql\/[\u4e3b\u673a\u540d].log\uff09\nshow variables like 'general_log_file';\n<\/code><\/pre>\n\n\n\n
      \n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \u4e09\u3001\u5b9e\u6218\uff1amydumper \u5907\u4efd\u64cd\u4f5c<\/h2>\n\n\n\n
      3.1 \u6267\u884c\u5907\u4efd\u547d\u4ee4<\/h3>\n\n\n\n
      \u4ee5\u5907\u4efd bak1<\/code> \u6570\u636e\u5e93\u4e3a\u4f8b\uff0c\u5907\u4efd\u6587\u4ef6\u5b58\u50a8\u81f3 \/data\/backup\/mydumper_bak\/bak1<\/code>\uff1a<\/p>\n\n\n\n
      cd \/data\/backup\/mydumper_bak\/<\/span>\nmydumper -u 'u_mydumper' -p 'Ud8agc_a' -S \/tmp\/mysql.sock -B bak1 -o .\/bak1<\/code><\/pre>\n\n\n\n
      3.2 \u5173\u952e\u53c2\u6570\u8bf4\u660e<\/h3>\n\n\n\n
      \u53c2\u6570<\/th>\u4f5c\u7528<\/th><\/tr><\/thead>
      -u<\/code><\/td>\u6307\u5b9a\u6570\u636e\u5e93\u7528\u6237\u540d<\/td><\/tr>
      -p<\/code><\/td>\u6307\u5b9a\u7528\u6237\u5bc6\u7801<\/td><\/tr>
      -S<\/code><\/td>MySQL \u5957\u63a5\u5b57\u6587\u4ef6\u8def\u5f84\uff08\u9ed8\u8ba4 \/tmp\/mysql.sock<\/code>\uff09<\/td><\/tr>
      -B<\/code><\/td>\u5f85\u5907\u4efd\u7684\u6570\u636e\u5e93\u540d<\/td><\/tr>
      -o<\/code><\/td>\u5907\u4efd\u6587\u4ef6\u8f93\u51fa\u76ee\u5f55<\/td><\/tr>
      -t<\/code><\/td>\u5e76\u53d1\u7ebf\u7a0b\u6570\uff08\u9ed8\u8ba4 4\uff0c\u53ef\u6309\u9700\u8c03\u6574\uff09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      3.3 \u5907\u4efd\u6587\u4ef6\u7ed3\u6784<\/h3>\n\n\n\n
      \u5907\u4efd\u5b8c\u6210\u540e\uff0c\u8fdb\u5165\u8f93\u51fa\u76ee\u5f55\u67e5\u770b\u6587\u4ef6\uff1a<\/p>\n\n\n\n
      cd \/data\/backup\/mydumper_bak\/bak1\nll  # \u5217\u51fa\u6240\u6709\u5907\u4efd\u6587\u4ef6<\/code><\/pre>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \u5178\u578b\u6587\u4ef6\u6e05\u5355\uff1a<\/p>\n\n\n\n
        \n
      • bak1-schema-create.sql<\/code>\uff1a\u6570\u636e\u5e93\u521b\u5efa\u8bed\u53e5\uff1b<\/li>\n\n\n\n
      • bak1.t1-schema.sql<\/code>\u3001bak1.t2-schema.sql<\/code>\uff1a\u8868\u7ed3\u6784\u6587\u4ef6\uff1b<\/li>\n\n\n\n
      • bak1.t1.00000.sql<\/code>\u3001bak1.t2.00000.sql<\/code>\uff1a\u8868\u6570\u636e\u6587\u4ef6\uff1b<\/li>\n\n\n\n
      • metadata<\/code>\uff1a\u5907\u4efd\u5143\u4fe1\u606f\uff08\u5907\u4efd\u65f6\u95f4\u3001GTID\u3001binlog \u4f4d\u70b9\u7b49\uff09\u3002<\/li>\n<\/ul>\n\n\n\n
         3.4 \u5206\u6790\u5907\u4efd\u8fc7\u7a0b\u7684 General Log<\/h3>\n\n\n\n
        \u901a\u8fc7 General Log \u53ef\u89c2\u5bdf mydumper \u7684\u5907\u4efd\u7ec6\u8282\uff0c\u5173\u952e\u64cd\u4f5c\u7247\u6bb5\u5982\u4e0b\uff08\u622a\u53d6\u90e8\u5206\u65e5\u5fd7\uff09\uff1a<\/p>\n\n\n\n
        2026-02-09T03:05:32.300231Z 28 Query\tFLUSH NO_WRITE_TO_BINLOG TABLES  -- \u5237\u65b0\u8868\u5230\u78c1\u76d8\n\n2026-02-09T03:05:32.307325Z 28 Query\tFLUSH TABLES WITH READ LOCK     -- \u52a0\u5168\u5c40\u8bfb\u9501\n\n2026-02-09T03:05:32.313811Z 32 Connect\tu_mydumper@localhost on  using Socket  -- \u521b\u5efa\u5b50\u7ebf\u7a0b\n\n2026-02-09T03:05:32.320569Z 31 Query\tSTART TRANSACTION \/*!40108 WITH CONSISTENT SNAPSHOT *\/  -- \u5f00\u542f\u4e8b\u52a1\n\n2026-02-09T03:05:32.377741Z 32 Query\tSELECT \/*!40001 SQL_NO_CACHE *\/ * FROM `bak1`.`t1`  -- \u8bfb\u53d6\u8868\u6570\u636e\n\n2026-02-09T03:05:32.382764Z 28 Query\tUNLOCK TABLES \/* FTWRL *\/  -- \u91ca\u653e\u5168\u5c40\u8bfb\u9501<\/code><\/pre>\n\n\n\n
        \u56db\u3001 mydumper \u5907\u4efd\u539f\u7406\u6df1\u5ea6\u89e3\u6790<\/h2>\n\n\n\n
        \u7ed3\u5408\u4e0a\u8ff0\u5b9e\u9a8c\u4e0e\u65e5\u5fd7\u5206\u6790\uff0cmydumper \u7684\u5907\u4efd\u6d41\u7a0b\u53ef\u62c6\u89e3\u4e3a\u4ee5\u4e0b 6 \u4e2a\u5173\u952e\u6b65\u9aa4\uff0c\u786e\u4fdd\u6548\u7387\u4e0e\u4e00\u81f4\u6027\u517c\u987e\uff1a<\/p>\n\n\n\n
          \n
        1. \u5237\u65b0\u8868\u6570\u636e\u5230\u78c1\u76d8<\/strong>\uff1a\u6267\u884c FLUSH NO_WRITE_TO_BINLOG TABLES<\/code>\uff0c\u5c06\u6240\u6709\u6253\u5f00\u7684\u8868\u7684\u810f\u9875\u5237\u65b0\u5230\u78c1\u76d8\uff0c\u907f\u514d\u5185\u5b58\u6570\u636e\u672a\u6301\u4e45\u5316\u5bfc\u81f4\u5907\u4efd\u4e0d\u5b8c\u6574\u3002<\/li>\n\n\n\n
        2. \u52a0\u5168\u5c40\u8bfb\u9501<\/strong>\uff1a\u4e3b\u7ebf\u7a0b\u6267\u884c FLUSH TABLES WITH READ LOCK<\/code>\uff0c\u9632\u6b62\u5907\u4efd\u8fc7\u7a0b\u4e2d\u5176\u4ed6\u4f1a\u8bdd\u4fee\u6539\u6570\u636e\uff08MyISAM \u8868\u4f9d\u8d56\u6b64\u9501\u4fdd\u969c\u4e00\u81f4\u6027\uff0cInnoDB \u8868\u540e\u7eed\u901a\u8fc7\u4e8b\u52a1\u5feb\u7167\u907f\u514d\u9501\u963b\u585e\uff09\u3002<\/li>\n\n\n\n
        3. \u521b\u5efa\u5b50\u7ebf\u7a0b\u5e76\u521d\u59cb\u5316\u4e8b\u52a1<\/strong>\uff1a\u9ed8\u8ba4\u521b\u5efa 4 \u4e2a\u5b50\u7ebf\u7a0b\uff08\u53ef\u901a\u8fc7 -t<\/code> \u53c2\u6570\u8c03\u6574\u7ebf\u7a0b\u6570\uff09\uff0c\u6bcf\u4e2a\u5b50\u7ebf\u7a0b\u8bbe\u7f6e\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u4e3a REPEATABLE READ\uff08RR\uff09<\/strong> \u5e76\u5f00\u542f\u4e8b\u52a1\uff0c\u83b7\u53d6\u4e00\u81f4\u6027\u5feb\u7167\u3002<\/li>\n\n\n\n
        4. \u83b7\u53d6\u5143\u4fe1\u606f\u4e0e\u8868\u7ed3\u6784<\/strong>\uff1a\u5b50\u7ebf\u7a0b\u5206\u522b\u67e5\u8be2\u6570\u636e\u5e93\u7684 GTID \u4fe1\u606f\u3001binlog \u4f4d\u70b9\uff0c\u4ee5\u53ca\u5404\u8868\u7684\u5efa\u8868\u8bed\u53e5\uff0c\u5b58\u50a8\u81f3\u5bf9\u5e94\u7684 schema \u6587\u4ef6\u3002<\/li>\n\n\n\n
        5. \u591a\u7ebf\u7a0b\u5e76\u53d1\u8bfb\u53d6\u6570\u636e<\/strong>\uff1a\u4e0d\u540c\u5b50\u7ebf\u7a0b\u901a\u8fc7 SELECT \/*!40001 SQL_NO_CACHE *\/ * FROM \u8868\u540d<\/code> \u8bed\u53e5\u8bfb\u53d6\u4e0d\u540c\u8868\u7684\u6570\u636e\uff0c\u907f\u514d\u4f7f\u7528\u7f13\u5b58\u63d0\u5347\u6548\u7387\uff0c\u5e76\u5c06\u6570\u636e\u5199\u5165\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6\u3002<\/li>\n\n\n\n
        6. \u91ca\u653e\u9501\u5e76\u7ed3\u675f\u7ebf\u7a0b<\/strong>\uff1a\u6240\u6709\u8868\u5907\u4efd\u5b8c\u6210\u540e\uff0c\u4e3b\u7ebf\u7a0b\u91ca\u653e\u5168\u5c40\u8bfb\u9501\uff08UNLOCK TABLES<\/code>\uff09\uff0c\u5b50\u7ebf\u7a0b\u63d0\u4ea4\u4e8b\u52a1\u5e76\u9000\u51fa\uff0c\u5907\u4efd\u4efb\u52a1\u5b8c\u6210\u3002<\/li>\n<\/ol>\n\n\n\n
          \u4e94\u3001\u5b9e\u6218\uff1amyloader \u6062\u590d\u64cd\u4f5c<\/h2>\n\n\n\n
          mydumper \u914d\u5957\u6062\u590d\u5de5\u5177 myloader<\/code> \u652f\u6301\u591a\u7ebf\u7a0b\u6062\u590d\uff0c\u64cd\u4f5c\u6d41\u7a0b\u5982\u4e0b\uff1a<\/p>\n\n\n\n
          5.1 \u6062\u590d\u524d\u51c6\u5907<\/h3>\n\n\n\n
          -- \u521b\u5efa\u76ee\u6807\u6062\u590d\u6570\u636e\u5e93\ncreate database bak1_recover;\n<\/code><\/pre>\n\n\n\n
          5.2 \u6267\u884c\u6062\u590d\u547d\u4ee4<\/h3>\n\n\n\n
          myloader -u 'u_mydumper' -p 'Ud8agc_a' -S \/tmp\/mysql.sock -B bak1_recover -d \/data\/backup\/mydumper_bak\/bak1\/\n<\/code><\/pre>\n\n\n\n
          5.3 \u9a8c\u8bc1\u6062\u590d\u7ed3\u679c<\/h3>\n\n\n\n
          use bak1_recover;\nshow tables;  -- \u786e\u8ba4\u8868\u7ed3\u6784\u5b58\u5728\nselect * from t1;  -- \u9a8c\u8bc1\u6570\u636e\u5b8c\u6574\u6027<\/code><\/pre>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
          5.4 \u5206\u6790\u6062\u590d\u8fc7\u7a0b\u7684 General Log<\/h3>\n\n\n\n
          \u901a\u8fc7 General Log \u53ef\u89c2\u5bdf myloader \u7684\u5907\u4efd\u7ec6\u8282\uff0c\u5173\u952e\u64cd\u4f5c\u7247\u6bb5\u5982\u4e0b\uff08\u622a\u53d6\u90e8\u5206\u65e5\u5fd7\uff09\uff1a<\/p>\n\n\n\n
          2026-02-09T03:22:52.480771Z\t   33 Connect\tu_mydumper@localhost on  using Socket  -- \u521b\u5efa\u5b50\u7ebf\u7a0b\n\n2026-02-09T03:22:52.504057Z\t   37 Query\tUSE `bak1_recover`  --\u5207\u6362\u5230\u76ee\u6807\u6062\u590d\u6570\u636e\u5e93\n\n2026-02-09T03:22:52.507328Z\t   35 Query\tCREATE TABLE `t2` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `a` varchar(20) DEFAULT NULL,\n  `b` int DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci   -- \u521b\u5efa\u8868\u7ed3\u6784\n\n2026-02-09T03:22:52.528705Z\t   34 Query\tSTART TRANSACTION -- \u5f00\u542f\u4e8b\u52a1\n\n2026-02-09T03:22:52.529636Z\t   34 Query\tINSERT INTO `t2` VALUES(1,\"one\",1)\n,(2,\"two\",2)   -- \u63d2\u5165\u6570\u636e\n\n2026-02-09T03:22:52.600323Z\t   34 Query\tCOMMIT  -- \u63d0\u4ea4\u4e8b\u52a1\n<\/code><\/pre>\n\n\n\n
          \u516d\u3001 myloader\u6062\u590d\u539f\u7406\u89e3\u6790<\/h2>\n\n\n\n
          myloader \u7684\u6062\u590d\u6d41\u7a0b\u4e0e mydumper \u7684\u5907\u4efd\u6d41\u7a0b\u76f8\u547c\u5e94\uff0c\u540c\u6837\u901a\u8fc7\u591a\u7ebf\u7a0b\u63d0\u5347\u6548\u7387\uff0c\u6838\u5fc3\u6b65\u9aa4\u5982\u4e0b\uff1a<\/p>\n\n\n\n
            \n
          1. \u521d\u59cb\u5316\u6062\u590d\u7ebf\u7a0b<\/strong>\uff1a\u521b\u5efa\u591a\u4e2a\u5b50\u7ebf\u7a0b\uff08\u9ed8\u8ba4\u4e0e\u5907\u4efd\u7ebf\u7a0b\u6570\u4e00\u81f4\uff09\uff0c\u5e76\u5207\u6362\u5230\u76ee\u6807\u6062\u590d\u6570\u636e\u5e93\uff08USE bak1_recover<\/code>\uff09\u3002<\/li>\n\n\n\n
          2. \u591a\u7ebf\u7a0b\u521b\u5efa\u8868\u7ed3\u6784<\/strong>\uff1a\u4e0d\u540c\u5b50\u7ebf\u7a0b\u5206\u522b\u6267\u884c\u5907\u4efd\u6587\u4ef6\u4e2d\u7684\u8868\u7ed3\u6784\u8bed\u53e5\uff08\u5982 CREATE TABLE<\/code>\uff09\uff0c\u786e\u4fdd\u8868\u7ed3\u6784\u5148\u4e8e\u6570\u636e\u521b\u5efa\u3002<\/li>\n\n\n\n
          3. \u5f00\u542f\u4e8b\u52a1\u5e76\u5199\u5165\u6570\u636e<\/strong>\uff1a\u6bcf\u4e2a\u5b50\u7ebf\u7a0b\u9488\u5bf9\u4e0d\u540c\u7684\u8868\u5f00\u542f\u4e8b\u52a1\uff0c\u6267\u884c INSERT<\/code> \u8bed\u53e5\u5c06\u5907\u4efd\u6570\u636e\u5199\u5165\u76ee\u6807\u8868\uff0c\u907f\u514d\u5355\u6761\u63d2\u5165\u5bfc\u81f4\u7684\u6027\u80fd\u95ee\u9898\u3002<\/li>\n\n\n\n
          4. \u63d0\u4ea4\u4e8b\u52a1<\/strong>\uff1a\u5355\u4e2a\u8868\u7684\u6570\u636e\u5199\u5165\u5b8c\u6210\u540e\uff0c\u5b50\u7ebf\u7a0b\u63d0\u4ea4\u4e8b\u52a1\uff0c\u786e\u4fdd\u6570\u636e\u6301\u4e45\u5316\u3002<\/li>\n\n\n\n
          5. \u6536\u5c3e\u4e0e\u9000\u51fa<\/strong>\uff1a\u6240\u6709\u8868\u6062\u590d\u5b8c\u6210\u540e\uff0c\u5b50\u7ebf\u7a0b\u9000\u51fa\uff0c\u6062\u590d\u6d41\u7a0b\u7ed3\u675f\u3002<\/li>\n<\/ol>\n\n\n\n
            \u603b\u7ed3<\/h2>\n\n\n\n
            mydumper \u51ed\u501f\u591a\u7ebf\u7a0b\u5e76\u53d1\u3001\u6587\u4ef6\u7ed3\u6784\u5316\u3001\u4e00\u81f4\u6027\u4fdd\u969c\u4e09\u5927\u6838\u5fc3\u4f18\u52bf\uff0c\u5b8c\u7f8e\u89e3\u51b3\u4e86\u4f20\u7edf\u5907\u4efd\u5de5\u5177\u901f\u5ea6\u6162\u3001\u6062\u590d\u7075\u6d3b\u5ea6\u4f4e\u7684\u75db\u70b9\u3002\u901a\u8fc7\u672c\u6587\u7684\u5b89\u88c5\u914d\u7f6e\u3001\u5b9e\u6218\u64cd\u4f5c\u4e0e\u539f\u7406\u89e3\u6790\uff0c\u76f8\u4fe1\u4f60\u5df2\u80fd\u719f\u7ec3\u8fd0\u7528 mydumper \u5b8c\u6210 MySQL \u6570\u636e\u5e93\u7684\u5907\u4efd\u4e0e\u6062\u590d\u5de5\u4f5c\u3002\u5728\u5b9e\u9645\u8fd0\u7ef4\u4e2d\uff0c\u53ef\u6839\u636e\u6570\u636e\u5e93\u89c4\u6a21\u8c03\u6574\u7ebf\u7a0b\u6570\uff08-t<\/code> \u53c2\u6570\uff09\uff0c\u7ed3\u5408\u5b9a\u65f6\u4efb\u52a1\uff08crontab\uff09\u5b9e\u73b0\u81ea\u52a8\u5316\u5907\u4efd\uff0c\u8fdb\u4e00\u6b65\u63d0\u5347\u6570\u636e\u5b89\u5168\u6027\u3002<\/p>\n\n\n\n
            <\/p>\n","protected":false},"excerpt":{"rendered":"
            \u5728 MySQL \u6570\u636e\u5e93\u8fd0\u7ef4\u4e2d\uff0c\u5907\u4efd\u662f\u6570\u636e\u5b89\u5168\u7684\u6838\u5fc3\u4fdd\u969c\u3002\u76f8\u8f83\u4e8e\u4f20\u7edf\u7684 mysqldump\uff0cmydumper \u51ed<\/p>\n
            \n\t\t\t\t Read More <\/span> <\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":564,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[16],"class_list":["post-553","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=553"}],"version-history":[{"count":7,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/553\/revisions"}],"predecessor-version":[{"id":905,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/553\/revisions\/905"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/media\/564"}],"wp:attachment":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}