{"id":286,"date":"2014-06-30T14:24:35","date_gmt":"2014-06-30T14:24:35","guid":{"rendered":"http:\/\/ixyzero.com\/blog\/?p=286"},"modified":"2014-06-30T14:24:35","modified_gmt":"2014-06-30T14:24:35","slug":"mysqldump%e6%95%b0%e6%8d%ae%e7%9a%84%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba","status":"publish","type":"post","link":"https:\/\/ixyzero.com\/blog\/archives\/286.html","title":{"rendered":"MySQLdump\u6570\u636e\u7684\u5bfc\u5165\u5bfc\u51fa"},"content":{"rendered":"<div><span style=\"color: #ff0000; font-size: large;\"><strong>MySQLdump\u53ea\u5bfc\u51fa\u8868\u7ed3\u6784\u6216\u53ea\u5bfc\u51fa\u6570\u636e\u7684\u5b9e\u73b0\u65b9\u6cd5<\/strong><\/span><\/div>\n<div><\/div>\n<div>\n<pre class=\"lang:default decode:true\">mysqldump  #\u53ea\u5bfc\u51fa\u8868\u7ed3\u6784\uff0c\u4e0d\u5bfc\u51fa\u6570\u636e\nmysqldump --opt -d \u6570\u636e\u5e93\u540d -u root -p &gt; xxx.sql<\/pre>\n<\/div>\n<h5>\u5907\u4efd\u6570\u636e\u5e93<\/h5>\n<div>\n<pre class=\"lang:default decode:true\">mysqldump \u6570\u636e\u5e93\u540d\u3000&gt;\u6570\u636e\u5e93\u5907\u4efd\u540d\nmysqldump -A -u\u7528\u6237\u540d -p\u5bc6\u7801 \u6570\u636e\u5e93\u540d&gt;\u6570\u636e\u5e93\u5907\u4efd\u540d\nmysqldump -d -A --add-drop-table -uroot -p &gt;xxx.sql<\/pre>\n<\/div>\n<h6>1.\u5bfc\u51fa\u7ed3\u6784\u4e0d\u5bfc\u51fa\u6570\u636e<\/h6>\n<div>\n<pre class=\"lang:default decode:true\">mysqldump --opt -d \u6570\u636e\u5e93\u540d -u root -p &gt; xxx.sql<\/pre>\n<\/div>\n<h6>2.\u5bfc\u51fa\u6570\u636e\u4e0d\u5bfc\u51fa\u7ed3\u6784<\/h6>\n<div>\n<pre class=\"lang:default decode:true\">mysqldump -t \u6570\u636e\u5e93\u540d -uroot -p &gt; xxx.sql<\/pre>\n<\/div>\n<h6>3.\u5bfc\u51fa\u6570\u636e\u548c\u8868\u7ed3\u6784<\/h6>\n<div>\n<pre class=\"lang:default decode:true\">mysqldump \u6570\u636e\u5e93\u540d -uroot -p &gt; xxx.sql<\/pre>\n<\/div>\n<h6>4.\u5bfc\u51fa\u7279\u5b9a\u8868\u7684\u7ed3\u6784<\/h6>\n<div>\n<pre class=\"lang:default decode:true\">mysqldump -uroot -p -B \u6570\u636e\u5e93\u540d --table \u8868\u540d &gt; xxx.sql<\/pre>\n<\/div>\n<h5><strong><span style=\"color: #ff0000;\">\u5bfc\u5165\u6570\u636e<\/span><\/strong>\uff1a<\/h5>\n<div>\u7531\u4e8emysqldump\u5bfc\u51fa\u7684\u662f\u5b8c\u6574\u7684SQL\u8bed\u53e5\uff0c\u6240\u4ee5\u7528mysql\u5ba2\u6237\u7a0b\u5e8f\u5f88\u5bb9\u6613\u5c31\u80fd\u628a\u6570\u636e\u5bfc\u5165\u4e86\uff1a<\/p>\n<pre class=\"lang:default decode:true  \">$ mysql \u6570\u636e\u5e93\u540d &lt; \u6587\u4ef6\u540d\n\u6216\nmysql&gt; source \/tmp\/xxx.sql<\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQLdump\u53ea\u5bfc\u51fa\u8868\u7ed3\u6784\u6216\u53ea\u5bfc\u51fa\u6570\u636e\u7684\u5b9e\u73b0\u65b9\u6cd5 mysqldump #\u53ea\u5bfc\u51fa\u8868\u7ed3\u6784\uff0c\u4e0d\u5bfc\u51fa\u6570\u636e mysq [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,6,12],"tags":[16,17],"class_list":["post-286","post","type-post","status-publish","format-standard","hentry","category-database","category-other","category-tools","tag-mysql","tag-mysqldump"],"views":3258,"_links":{"self":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts\/286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/comments?post=286"}],"version-history":[{"count":0,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts\/286\/revisions"}],"wp:attachment":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/media?parent=286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/categories?post=286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/tags?post=286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}