{"id":44,"date":"2019-12-18T10:12:06","date_gmt":"2019-12-18T02:12:06","guid":{"rendered":"http:\/\/blog.ohmmx.com\/?p=44"},"modified":"2019-12-18T10:21:37","modified_gmt":"2019-12-18T02:21:37","slug":"mysql%e5%af%bc%e5%87%ba%e5%af%bc%e5%85%a5","status":"publish","type":"post","link":"http:\/\/blog.ohmmx.com\/?p=44","title":{"rendered":"MySQL\u5bfc\u51fa\u5bfc\u5165"},"content":{"rendered":"\n<p>\u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -h [host] -P [port] -u [user] -p [dbname] > [dbfile].sql<\/code><\/pre>\n\n\n\n<p>\u5bfc\u51fa\u6570\u636e\u5e93\u7ed3\u6784\uff08\u6ca1\u6709\u6570\u636e\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -h [host] -P [port] -u [user] -p -d [dbname] > [dbfile].sql<\/code><\/pre>\n\n\n\n<p>\u5bfc\u51fa\u4e00\u5f20\u8868<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -h [host] -P [port] -u [user] -p [dbname] [tablename1] [tablename2] > [db_tablefile].sql<\/code><\/pre>\n\n\n\n<p>\u5bfc\u51fa\u4e00\u5f20\u8868\u7ed3\u6784<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -h [host] -P [port] -u [user] -p -d [dbname] [tablename1] [tablename2] > [db_tablefile].sql<\/code><\/pre>\n\n\n\n<p>\u5220\u9664\u6570\u636e\u5e93\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP DATABASE IF EXISTS [dbname];<\/code><\/pre>\n\n\n\n<p>\u521b\u5efa\u6570\u636e\u5e93<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE [dbname] DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;<\/code><\/pre>\n\n\n\n<p>CHARACTER SET\u53ef\u4ee5\u7528utf8\u6216\u8005utf8mb4\uff0c\u540e\u8005\u662f\u6807\u51c64\u5b57\u8282utf8\uff0c\u652f\u6301emoji\u3002\u5efa\u8bae\u4f7f\u7528\u540e\u8005\u3002<\/p>\n\n\n\n<p>\u5bf9\u5e94\u7684COLLATE\u53ef\u4ee5\u4f7f\u7528utf8_general_ci\u6216\u8005utf8_bin\uff08\u5bf9\u5e94\u7684utf8mb4_general_ci\u548cutf8mb4_bin\uff09\uff0c\u5176\u4e2dgeneral_ci\u4e0d\u533a\u5206\u5b57\u6bb5\u5185\u5bb9\u5927\u5c0f\u5199\uff0cbin\u533a\u5206\u3002\u5efa\u8bae\u4f7f\u7528\u524d\u8005\uff0c\u5728\u521b\u5efa\u5bc6\u7801\u8868\u7684\u65f6\u5019\u53ef\u4ee5\u5bf9\u8868\u5355\u72ec\u8bbe\u7f6eCOLLATE\u3002<\/p>\n\n\n\n<p>\u5bfc\u5165\u6570\u636e\u5e93<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SOURCE [path]\/[dbname].sql<\/code><\/pre>\n\n\n\n<p>\u5728\u5b9e\u9645\u4f7f\u7528\u8fc7\u7a0b\u4e2d\uff0c\u9ed8\u8ba4\u5bfc\u51fa\u7684\u6570\u636e\u5e93\u6587\u4ef6\u4f1a\u5f88\u5927\uff0c\u6211\u4eec\u53ef\u4ee5\u5728\u5bfc\u51fa\u7684\u8fc7\u7a0b\u4e2d\u8fdb\u884c\u538b\u7f29\uff0c\u8fd9\u91cc\u91c7\u7528\u4e3b\u6d41\u7684gzip\u548cxz\u5bf9\u5907\u4efd\u6587\u4ef6\u8fdb\u884c\u538b\u7f29\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -h &#91;host] -P &#91;port] -u &#91;user] -p &#91;dbname] | gzip > &#91;dbfile].sql.gz\nmysqldump -h &#91;host] -P &#91;port] -u &#91;user] -p &#91;dbname] | xz > &#91;dbfile].sql.xz<\/code><\/pre>\n\n\n\n<p>\u76f8\u5bf9\u5e94\u7684\u5bfc\u5165<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gzip -dc &lt; &#91;dbfile].sql.gz | mysql -h &#91;host] -u &#91;user] -P &#91;port] -p &#91;dbname]\nxz -dc &lt; &#91;dbfile].sql.xz | mysql -h &#91;host] -u &#91;user] -P &#91;port] -p &#91;dbname]<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93\uff1a \u5bfc\u51fa\u6570\u636e\u5e93\u7ed3\u6784\uff08\u6ca1\u6709\u6570\u636e\uff09 \u5bfc\u51fa\u4e00\u5f20\u8868 \u5bfc\u51fa\u4e00\u5f20\u8868\u7ed3\u6784 \u5220\u9664\u6570 &hellip; <a href=\"http:\/\/blog.ohmmx.com\/?p=44\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[9],"class_list":["post-44","post","type-post","status-publish","format-standard","hentry","category-17","tag-mysql"],"_links":{"self":[{"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=\/wp\/v2\/posts\/44","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=44"}],"version-history":[{"count":2,"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=\/wp\/v2\/posts\/44\/revisions"}],"predecessor-version":[{"id":46,"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=\/wp\/v2\/posts\/44\/revisions\/46"}],"wp:attachment":[{"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=44"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=44"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.ohmmx.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=44"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}