{"id":944,"date":"2026-04-21T02:52:16","date_gmt":"2026-04-21T02:52:16","guid":{"rendered":"https:\/\/opshub.com.cn\/?p=944"},"modified":"2026-04-23T07:51:59","modified_gmt":"2026-04-23T07:51:59","slug":"xtrabackup8-0%e5%af%b9%e5%ae%b9%e5%99%a8%e5%86%85%e7%9a%84mysql%e8%bf%9b%e8%a1%8c%e5%a4%87%e4%bb%bd%e5%92%8c%e8%bf%98%e5%8e%9f","status":"publish","type":"post","link":"https:\/\/opshub.com.cn\/?p=944","title":{"rendered":"Xtrabackup8.0\u5bf9\u5bb9\u5668\u5185\u7684mysql\u8fdb\u884c\u5907\u4efd\u548c\u8fd8\u539f"},"content":{"rendered":"\n<p>\u5907\u4efd\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker run --rm --name percona-xtrabackup --volumes-from zentao-mysql --network container:zentao-mysql -v \/appdata\/zentao\/full_db_backup:\/backup --user root percona\/percona-xtrabackup:8.0.27 xtrabackup --backup --datadir=\/var\/lib\/mysql --target-dir=\/backup --host=127.0.0.1 --port=3306 --user=root --password='7da6b87c0ff9'<\/code><\/pre>\n\n\n\n<p><strong><code>--network container:zentao-mysql<\/code><\/strong>: \u8ba9\u5907\u4efd\u5bb9\u5668\u5171\u4eab MySQL \u5bb9\u5668\u7684\u7f51\u7edc\u547d\u540d\u7a7a\u95f4\uff0c\u8fd9\u6837 <code>127.0.0.1<\/code> \u5c31\u6307\u5411\u4e86 MySQL \u5bb9\u5668\u3002<\/p>\n\n\n\n<p><strong><code>--host=127.0.0.1<\/code><\/strong>: \u5f3a\u5236 XtraBackup \u4f7f\u7528 TCP \u800c\u975e Socket \u8fde\u63a5\u3002<\/p>\n\n\n\n<p><strong><code>--user<\/code> &amp; <code>--password<\/code><\/strong>: \u5fc5\u987b\u63d0\u4f9b\u6570\u636e\u5e93\u8d26\u53f7\u5bc6\u7801\u3002<\/p>\n\n\n\n<p>\u6062\u590d\uff1a<\/p>\n\n\n\n<p>1\u3001\u5148\u628a\u5907\u4efd\u6587\u4ef6\u51c6\u5907\u597d\uff08apply log\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker run --rm -v \/appdata\/zentao\/full_db_backup:\/backup percona\/percona-xtrabackup:8.0.27 xtrabackup --prepare --target-dir=\/backup<\/code><\/pre>\n\n\n\n<p>2\u3001\u6062\u590d\u524d\u51c6\u5907\uff0c\u5148\u505cmysql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker stop zentao-mysql<\/code><\/pre>\n\n\n\n<p>3\u3001\u5148\u628a\u6570\u636e\u5e93\u76ee\u5f55\uff08\u6620\u5c04\u5230\u5bbf\u4e3b\u673a\u7684\uff09\u91cd\u547d\u540d\u5907\u4efd\u4e00\u4e0b (mv)<\/p>\n\n\n\n<p>4\u3001\u5f00\u59cb\u6062\u590d\uff08\u8986\u76d6\u6570\u636e\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker run --rm --volumes-from zentao-mysql \\\n-v \/appdata\/zentao\/full_db_backup:\/backup \\\npercona\/percona-xtrabackup:8.0.27 \\\nxtrabackup --copy-back --datadir=\/var\/lib\/mysql --target-dir=\/backup<\/code><\/pre>\n\n\n\n<p>5\u3001\u6062\u590d\u6743\u9650\u5e76\u542f\u52a8<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker start zentao-mysql<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5907\u4efd\uff1a &#8211;network container:zentao-mysql: \u8ba9\u5907\u4efd\u5bb9\u5668\u5171\u4eab MySQL \u5bb9\u5668\u7684\u7f51\u7edc\u547d\u540d\u7a7a\u95f4\uff0c\u8fd9\u6837 127.0.0.1 \u5c31\u6307\u5411\u4e86 MySQL \u5bb9\u5668\u3002 &#8211;host=127.0.0.1: \u5f3a\u5236 XtraBackup \u4f7f\u7528 TCP \u800c\u975e Socket \u8fde\u63a5\u3002 &#8211;user &amp; &#8211;password: \u5fc5\u987b\u63d0\u4f9b\u6570\u636e\u5e93\u8d26\u53f7\u5bc6\u7801\u3002 \u6062\u590d\uff1a 1\u3001\u5148\u628a\u5907\u4efd\u6587\u4ef6\u51c6\u5907\u597d\uff08apply log\uff09 2\u3001\u6062\u590d\u524d\u51c6\u5907\uff0c\u5148\u505cmysql 3\u3001\u5148\u628a\u6570\u636e\u5e93\u76ee\u5f55\uff08\u6620\u5c04\u5230\u5bbf\u4e3b\u673a\u7684\uff09\u91cd\u547d\u540d\u5907\u4efd\u4e00\u4e0b (mv) 4\u3001\u5f00\u59cb\u6062\u590d\uff08\u8986\u76d6\u6570\u636e\uff09 5\u3001\u6062\u590d\u6743\u9650\u5e76\u542f\u52a8<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,8],"tags":[],"class_list":["post-944","post","type-post","status-publish","format-standard","hentry","category-dockerkubernetes","category-8"],"_links":{"self":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/944","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=944"}],"version-history":[{"count":3,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/944\/revisions"}],"predecessor-version":[{"id":952,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/944\/revisions\/952"}],"wp:attachment":[{"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opshub.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}