{"id":6309,"date":"2026-11-05T09:25:17","date_gmt":"2026-11-05T00:25:17","guid":{"rendered":"https:\/\/core.nsme.net\/notes\/?p=6309"},"modified":"2026-11-05T09:25:17","modified_gmt":"2026-11-05T00:25:17","slug":"%e5%b7%a8%e5%a4%a7sql%e3%81%ae%e3%83%80%e3%83%b3%e3%83%97%e3%81%a8%e3%83%aa%e3%82%b9%e3%83%88%e3%82%a2","status":"publish","type":"post","link":"https:\/\/core.nsme.net\/notes\/mysql\/6309\/","title":{"rendered":"\u5de8\u5927SQL\u306e\u30c0\u30f3\u30d7\u3068\u30ea\u30b9\u30c8\u30a2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u65e5\u5e38\u7684\u306a\u904b\u7528\u30fb\u7d20\u65e9\u3044\u30ea\u30b9\u30c8\u30a2\u3082\u91cd\u8996\u3057\u305f\u3044\uff08\u73fe\u5b9f\u7684\u306a\u6700\u5f37\u5019\u88dc\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u3082\u304a\u3059\u3059\u3081\u306a\u306e\u306f <strong><code>Zstd<\/code> (Zstandard)<\/strong> \u3067\u3059\u3002<br><code>gzip<\/code> \u3092\u9065\u304b\u306b\u51cc\u99d5\u3059\u308b\u5727\u5012\u7684\u306a\u30b9\u30d4\u30fc\u30c9\u3067\u3042\u308a\u306a\u304c\u3089\u3001<code>gzip<\/code> \u4ee5\u4e0a\u306e\u5727\u7e2e\u7387\uff08\u3092\u5b9f\u73fe\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u8df5\u7684\u306a\u30b3\u30de\u30f3\u30c9\u4f8b<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5de8\u5927\u306aSQL\u30c0\u30f3\u30d7\u306e\u5834\u5408\u3001\u4e00\u5ea6\u30c7\u30a3\u30b9\u30af\u306b\u672a\u5727\u7e2e\u306e\u751fSQL\uff08.sql\uff09\u3092\u66f8\u304d\u51fa\u3059\u3068\u3001\u305d\u308c\u3060\u3051\u3067\u30c7\u30a3\u30b9\u30af\u30d5\u30eb\uff08\u5bb9\u91cf\u67af\u6e07\uff09\u306b\u306a\u308b\u5371\u967a\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001<strong>\u30c0\u30f3\u30d7\u3057\u306a\u304c\u3089\u30d1\u30a4\u30d7\uff08<code>|<\/code>\uff09\u3067\u76f4\u63a5\u5727\u7e2e\u306b\u6d41\u3057\u8fbc\u3080<\/strong>\u306e\u304c\u9244\u5247\u3067\u3059\u3002<br> Zstd \u3067\u9ad8\u901f\u30fb\u9ad8\u5727\u7e2e\u30c0\u30f3\u30d7\u3059\u308b\uff08\u63a8\u5968\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">bash<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u30c0\u30f3\u30d7\uff0b\u5727\u7e2e\nmysqldump -u &#91;\u30e6\u30fc\u30b6\u30fc] -p &#91;DB\u540d] | zstd -T0 -o sns.sql.zst\n\n# \u89e3\u51cd\u305b\u305a\u306b\u305d\u306e\u307e\u307eMySQL\u3078\u6d41\u3057\u8fbc\u3093\u3067\u30ea\u30b9\u30c8\u30a2\nzstdcat sns.sql.zst | mysql -u &#91;\u30e6\u30fc\u30b6\u30fc] -p &#91;DB\u540d]<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u65e5\u5e38\u7684\u306a\u904b\u7528\u30fb\u7d20\u65e9\u3044\u30ea\u30b9\u30c8\u30a2\u3082\u91cd\u8996\u3057\u305f\u3044\uff08\u73fe\u5b9f\u7684\u306a\u6700\u5f37\u5019\u88dc\uff09 \u6700\u3082\u304a\u3059\u3059\u3081\u306a\u306e\u306f Zstd (Zstandard) \u3067\u3059\u3002gzip \u3092\u9065\u304b\u306b\u51cc\u99d5\u3059\u308b\u5727\u5012\u7684\u306a\u30b9\u30d4\u30fc\u30c9\u3067\u3042\u308a\u306a\u304c\u3089\u3001gzip \u4ee5\u4e0a\u306e\u5727\u7e2e\u7387\uff08\u3092\u5b9f\u73fe\u3057\u307e\u3059\u3002 \u5b9f [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[],"class_list":["post-6309","post","type-post","status-publish","format-standard","hentry","category-mysql"],"acf":[],"_links":{"self":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/comments?post=6309"}],"version-history":[{"count":1,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6309\/revisions"}],"predecessor-version":[{"id":6310,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6309\/revisions\/6310"}],"wp:attachment":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/media?parent=6309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/categories?post=6309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/tags?post=6309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}