{"id":1882,"date":"2020-04-10T11:55:34","date_gmt":"2020-04-10T03:55:34","guid":{"rendered":"http:\/\/www.ouvps.com\/?p=1882"},"modified":"2020-04-10T11:55:42","modified_gmt":"2020-04-10T03:55:42","slug":"mysql%e5%8f%aa%e5%af%bc%e5%87%ba%e8%a1%a8%e7%bb%93%e6%9e%84%e6%88%96%e5%8f%aa%e5%af%bc%e5%87%ba%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"https:\/\/eepu.top\/?p=1882","title":{"rendered":"Mysql\u53ea\u5bfc\u51fa\u8868\u7ed3\u6784\u6216\u53ea\u5bfc\u51fa\u6570\u636e"},"content":{"rendered":"\n<h2>\u53ea\u5bfc\u51fa\u8868\u7ed3\u6784 \u4e0d\u5bfc\u51fa\u6570\u636e<\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump --opt -d \u6570\u636e\u5e93\u540d -u root -p &gt; xxx.sql\n<\/pre>\n\n\n\n<h2>\u5bfc\u51fa\u6570\u636e\u4e0d\u5bfc\u51fa\u7ed3\u6784<\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump\u3000-t\u3000\u6570\u636e\u5e93\u540d\u3000-uroot\u3000-p\u3000&gt;\u3000xxx.sql\n<\/pre>\n\n\n\n<h2>\u5bfc\u51fa\u6570\u636e\u548c\u8868\u7ed3\u6784<\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump\u3000\u6570\u636e\u5e93\u540d\u3000-uroot\u3000-p\u3000--default-character-set=utf8 &gt;\u3000xxx.sql\n<\/pre>\n\n\n\n<h2>\u5bfc\u51fa\u7279\u5b9a\u8868\u7684\u7ed3\u6784<\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump\u3000-uroot\u3000-p\u3000-B\u3000\u6570\u636e\u5e93\u540d\u3000--table\u3000\u8868\u540d\u3000&gt;\u3000xxx.sql\n<\/pre>\n\n\n\n<h2>\u5bfc\u51fa\u51fd\u6570\u53ca\u5b58\u50a8\u8fc7\u7a0b<\/h2>\n\n\n(-ntd\u8868\u793a\u4e0d\u5bfc\u51fa\u8868\u7ed3\u6784\u548c\u6570\u636e,-R\u8868\u793a\u5bfc\u51fa\u51fd\u6570\u53ca\u5b58\u50a8\u8fc7\u7a0b)\n\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump\u3000-uroot\u3000-p\u3000-ntd -R\u3000\u6570\u636e\u5e93\u540d\u3000&gt;\u3000xxx.sql<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u53ea\u5bfc\u51fa\u8868\u7ed3\u6784 \u4e0d\u5bfc\u51fa\u6570\u636e mysqldump &#8211;opt -d \u6570\u636e\u5e93\u540d -u root -p &gt; xx [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[75],"tags":[],"_links":{"self":[{"href":"https:\/\/eepu.top\/index.php?rest_route=\/wp\/v2\/posts\/1882"}],"collection":[{"href":"https:\/\/eepu.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eepu.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eepu.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eepu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1882"}],"version-history":[{"count":2,"href":"https:\/\/eepu.top\/index.php?rest_route=\/wp\/v2\/posts\/1882\/revisions"}],"predecessor-version":[{"id":1884,"href":"https:\/\/eepu.top\/index.php?rest_route=\/wp\/v2\/posts\/1882\/revisions\/1884"}],"wp:attachment":[{"href":"https:\/\/eepu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eepu.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eepu.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}