{"id":151884,"date":"2020-08-30T10:31:23","date_gmt":"2020-08-30T02:31:23","guid":{"rendered":"http:\/\/4563.org\/?p=151884"},"modified":"2020-08-30T10:31:23","modified_gmt":"2020-08-30T02:31:23","slug":"%e6%b1%82%e6%8e%a8%e8%8d%90%e6%96%b9%e4%be%bf%e5%a5%bd%e7%94%a8%e7%9a%84%e6%95%b0%e6%8d%ae%e5%ba%93%e5%90%8c%e6%ad%a5%e5%b7%a5%e5%85%b7%ef%bc%9f","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=151884","title":{"rendered":"\u6c42\u63a8\u8350\u65b9\u4fbf\u597d\u7528\u7684\u6570\u636e\u5e93\u540c\u6b65\u5de5\u5177\uff1f"},"content":{"rendered":"
\n
\n
\n

\u6c42\u63a8\u8350\u65b9\u4fbf\u597d\u7528\u7684\u6570\u636e\u5e93\u540c\u6b65\u5de5\u5177\uff1f <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : zealinux <\/span> <\/i> 5<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

\u4e3b\u8981\u662f\u540c\u6b65\u8868\u7ed3\u6784\u548c\u8fd9\u4e9b\u90e8\u5206\u8868\u91cc\u7684\u4e00\u4e9b\u6570\u636e\u3002<\/p>\n

\u4e3b\u8981\u662f\u7528\u5230\u5341\u591a\u4e2a\u4e0d\u540c\u7684\u6570\u636e\u5e93\uff0c \u5982\u679c\u7528 mysqldump \u7a0d\u5fae\u6709\u70b9\u7d2f\u3002<\/p>\n

\u5982\u679c\u6709\u5bf9\u4e8e mysqldump \u7684\u4e8c\u6b21\u5f00\u53d1\u5c31\u66f4\u597d\u4e86\u3002<\/p>\n<\/p><\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (17<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : RockShake <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ef\u4ee5\u8bd5\u4e00\u4e0b\u963f\u91cc\u5df4\u5df4\u7684 Canal<\/p>\n

    https:\/\/github.com\/alibaba\/canal <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : gz911122 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    datax <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : yukong <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    datax <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : zealinux <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @gz911122 <\/p>\n

    datax \u592a\u91cd\u4e86\u5427\uff0c\u592a\u590d\u6742\u4e86\u5427\u3002
    \u6211\u5c31\u60f3\u8981\u4e2a\u7b80\u5355\u6613\u7528\u7684\u547d\u4ee4\u884c\u5de5\u5177\u6216\u8005 GUI \u5de5\u5177\uff0c
    \u53ea\u8981\u586b\u6e90 MySQL \u5730\u5740\uff0c\u548c\u76ee\u6807 MySQL \u5730\u5740\u540c\u6b65\u8868\u7ed3\u6784\uff0c
    \u5982\u679c\u540c\u6b65\u8868\u5185\u5bb9\uff0c\u53ea\u8981\u52fe\u9009\u4e00\u4e0b\u5c31\u540c\u6b65\u8868\u5185\u5bb9\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : poisedflw <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    navicat <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : yoqu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    Navicat \u5c31\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : zealinux <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @poisedflw @yoqu Navicat \u4e0d\u53ef\u4ee5\u9009\u62e9\u90e8\u5206\u8868\u8fdb\u884c\u540c\u6b65\u6570\u636e <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : 263 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    MySQL \u53ef\u4ee5\u7528 Xtrabackup \u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : poisedflw <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @zealinux \u53ef\u4ee5\u554a\uff0cNavicat Premium\uff0c\u5bf9\u6bd4\u7684\u65f6\u5019\u6709\u300e\u6e90\u300f\u548c\u300e\u76ee\u6807\u300f\uff0c\u4e2d\u95f4\u4e0d\u662f\u6709\u52fe\u9009\u529f\u80fd\u4e48 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : jiezhi <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u56e0\u4e3a\u5728\u516c\u53f8\u7ecf\u5e38\u6709\u540c\u6b65\u6570\u636e\u9700\u6c42\uff0c\u6240\u4ee5\u6211\u81ea\u5df1\u5199\u4e86\u4e2a\uff0c\u8fd8\u652f\u6301\u5f02\u6784\u540c\u6b65 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : arthas2234 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    Navicat+1 \u6bcf\u6b21\u90fd\u7528\u8fd9\u4e2a\u540c\u6b65\u8868\u7ed3\u6784\uff0c\u53ef\u4ee5\u52fe\u9009\u8981\u540c\u6b65\u7684\u8868\u548c\u91cc\u9762\u7684\u5b57\u6bb5 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : daimaosix <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8bd5\u8bd5\u968f\u884c\u4ed8\u5f00\u6e90\u7684 Porter\uff0c\u6211\u4eec\u4e4b\u524d\u7528\u8fc7\uff0c\u8fd8\u4e0d\u9519\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : fenglangjuxu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    https:\/\/github.com\/weichangdong\/sync-mysql-schema-data
    \u53ef\u4ee5\u8bd5\u4e0b\u8fd9\u4e2a <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : fanpei0121 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    sqlyog <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : statement <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    ogg <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : dq19871123 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    Navicat \u503c\u5f97\u62e5\u6709 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : promise2mm <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    9L \u6b63\u89e3 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    \u6c42\u63a8\u8350\u65b9\u4fbf\u597d\u7528\u7684\u6570\u636e\u5e93\u540c\u6b65\u5de5\u5177\uff1f …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/151884"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=151884"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/151884\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=151884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=151884"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=151884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}