{"id":1420,"date":"2016-03-02T10:41:55","date_gmt":"2016-03-02T02:41:55","guid":{"rendered":"http:\/\/nick.txtcc.com\/?p=1420"},"modified":"2016-03-02T10:41:56","modified_gmt":"2016-03-02T02:41:56","slug":"%e7%94%a8gzipgunzip%e5%a4%87%e4%bb%bd%ef%bc%8c%e5%8e%8b%e7%bc%a9%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/nick.txtcc.com\/index.php\/linux\/1420","title":{"rendered":"\u7528gzip\/gunzip\u5907\u4efd\uff0c\u538b\u7f29\u6570\u636e\u5e93"},"content":{"rendered":"<p>\u7f18\u8d77\uff1a\u516c\u53f8\u670d\u52a1\u5668\u4e0a\u6570\u636e\u5e93\u8d8a\u6765\u8d8a\u5927\uff0c\u4ee5\u524d\u5907\u4efd\u6570\u636e\u65f6\u5c06\u6570\u636e\u5e93\u6574\u4e2adump\u51fa\u6765\uff0c\u7136\u540e\u7528tar czvf\u538b\u7f29\u5907\u4efd\uff0c\u8fd8\u539f\u65f6\u7528tar zxvf\u89e3\u538b\u7f29\uff0c\u6bcf\u6b21\u90fd\u4f5c\u8fd9\u79cd\u4e8b\u60c5\u7684\u786e\u5f88\u70e6\u3002<\/p>\n<p>\u6d4f\u89c8PostgreSQL\u6587\u6863\u65f6\uff0c\u770b\u5230\u4ecb\u7ecd\u6570\u636e\u5e93\u5907\u4efd\u90e8\u5206\u7684\u5185\u5bb9\u65f6\uff0c\u627e\u5230\u4e00\u4e2a\u4e0d\u9519\u7684\u529e\u6cd5\u53ef\u4ee5\u76f4\u63a5\u5c06\u6570\u636e\u5e93dump\u51fa\u6765\u5e76\u81ea\u52a8\u538b\u7f29\uff0c\u8fd8\u539f\u6570\u636e\u5e93\u4e5f\u53ef\u4ee5\u4ece\u538b\u7f29\u6587\u4ef6\u76f4\u63a5\u8fd8\u539f\u5230\u6570\u636e\u5e93\uff0c\u539f\u6765\u6570\u636e\u5e93dump\u51fa\u6765\u5927\u698250\u591aM\u7684plain text\u6587\u4ef6\u538b\u7f29\u540e\u53ea\u6709\u4e0d\u52307MB\uff0c\u975e\u5e38\u5229\u4e8e\u7f51\u7edc\u4f20\u8f93\uff0c\u4e14\u539f\u7406\u5e76\u4e0d\u590d\u6742\uff0c\u53ea\u7528\u5230\u4e86Linux\u7684gzip\/gunzip\u548c\u7ba1\u9053\u547d\u4ee4\u800c\u5df2\u3002<\/p>\n<p>MySQL:<\/p>\n<div id=\"\" class=\"dp-highlighter\">\n<div class=\"bar\">\n<div class=\"tools\">Ruby\u4ee3\u7801 <embed src=\"http:\/\/lgn21st.iteye.com\/javascripts\/syntaxhighlighter\/clipboard_new.swf\" type=\"application\/x-shockwave-flash\" width=\"14\" height=\"15\"><\/embed>\u00a0<a title=\"\u6536\u85cf\u8fd9\u6bb5\u4ee3\u7801\"><img decoding=\"async\" class=\"star\" src=\"http:\/\/nick.txtcc.com\/wp-content\/uploads\/remote_image\/2016\/03\/0241563CV.png\" alt=\"\u6536\u85cf\u4ee3\u7801\"><\/a><\/div>\n<\/div>\n<ol class=\"dp-rb\" start=\"1\">\n    <li><span class=\"comment\">#\u00a0Backup<\/span><\/li>\n    <li>mysqldump\u00a0-u\u00a0username\u00a0-p\u00a0dbname\u00a0|\u00a0gzip\u00a0>\u00a0outfile.gz<\/li>\n    <li><span class=\"comment\">#\u00a0Restore<\/span><\/li>\n    <li>cat\u00a0outfile.gz\u00a0|\u00a0gunzip\u00a0|\u00a0mysql\u00a0-u\u00a0username\u00a0-p\u00a0dbname<\/li>\n<\/ol>\n<\/div>\n<p>PosgreSQL:<\/p>\n<div id=\"\" class=\"dp-highlighter\">\n<div class=\"bar\">\n<div class=\"tools\">Ruby\u4ee3\u7801 <embed src=\"http:\/\/lgn21st.iteye.com\/javascripts\/syntaxhighlighter\/clipboard_new.swf\" type=\"application\/x-shockwave-flash\" width=\"14\" height=\"15\"><\/embed>\u00a0<a title=\"\u6536\u85cf\u8fd9\u6bb5\u4ee3\u7801\"><img decoding=\"async\" class=\"star\" src=\"http:\/\/nick.txtcc.com\/wp-content\/uploads\/remote_image\/2016\/03\/0241563CV.png\" alt=\"\u6536\u85cf\u4ee3\u7801\"><\/a><\/div>\n<\/div>\n<ol class=\"dp-rb\" start=\"1\">\n    <li><span class=\"comment\">#\u00a0Backup<\/span><\/li>\n    <li>pg_dump\u00a0dbname\u00a0|\u00a0gzip\u00a0>\u00a0outfile.gz<\/li>\n    <li><span class=\"comment\">#\u00a0Restore<\/span><\/li>\n    <li>cat\u00a0outfile.gz\u00a0|\u00a0gunzip\u00a0|\u00a0psql\u00a0dbname<\/li>\n<\/ol>\n<\/div>\n<p>\u8fd8\u53ef\u4ee5\u8fdc\u7a0b\u5907\u4efd\/\u8fd8\u539f\uff0c\u62ffPosgreSQL\u4e3e\u4f8b\uff1a<\/p>\n<div id=\"\" class=\"dp-highlighter\">\n<div class=\"bar\">\n<div class=\"tools\">Ruby\u4ee3\u7801 <embed src=\"http:\/\/lgn21st.iteye.com\/javascripts\/syntaxhighlighter\/clipboard_new.swf\" type=\"application\/x-shockwave-flash\" width=\"14\" height=\"15\"><\/embed>\u00a0<a title=\"\u6536\u85cf\u8fd9\u6bb5\u4ee3\u7801\"><img decoding=\"async\" class=\"star\" src=\"http:\/\/nick.txtcc.com\/wp-content\/uploads\/remote_image\/2016\/03\/0241563CV.png\" alt=\"\u6536\u85cf\u4ee3\u7801\"><\/a><\/div>\n<\/div>\n<ol class=\"dp-rb\" start=\"1\">\n    <li>pg_dump\u00a0-h\u00a0host1\u00a0dbname\u00a0|\u00a0psql\u00a0-h\u00a0host2\u00a0dbname<\/li>\n<\/ol>\n<\/div>\n<p>\u8fd9\u79cd\u7528\u6cd5\u867d\u7136\u57fa\u7840\uff0c\u4f46\u786e\u8ba9\u6211\u53c8\u4e00\u6b21\u4f53\u4f1a\u5230\u4e86Linux\/Unix\u4e0b\u9762\u7684\u5de5\u5177\uff0c\u4f5c\u4e00\u4ef6\u5c0f\u4e8b\uff0c\u5e76\u628a\u4ed6\u505a\u597d\u8fd9\u4e2a\u539f\u5219\u3002\u81ea\u5df1\u5199\u4ee3\u7801\u6a21\u5757\u7684\u65f6\u5019\uff0c\u4e60\u60ef\u628a\u5173\u8054\u529f\u80fd\u96c6\u6210\u5728\u4e00\u8d77\uff0c\u6bd4\u5982\u4e00\u4e2aencrypt\u6a21\u5757\uff0c\u6211\u4f1a\u628a\u52a0\u5bc6\/\u89e3\u5bc6\u4e24\u4e2a\u65b9\u6cd5\u6210\u5bf9\u5199\u6210\u4e00\u4e2ascope\u4e2d\uff0c\u4e14\u5176\u4ed6\u4eba\u5927\u62b5\u4e5f\u591a\u662f\u5982\u6b64\u64cd\u4f5c\uff0c\u5408\u4e4e\u5e38\u7406\u5440\u3002\u4f46\u662fLinux\u4e0b\u9762\u5c31\u628a\u538b\u7f29\uff0c\u89e3\u538b\u7f29\u7528\u4e24\u4e2a\u7a0b\u5e8f\u6765\u5904\u7406(gzip\/gunzip)\uff0c\u7136\u540e\u7528\u7ba1\u9053\u628a\u4ed6\u4eec\u4e32\u8054\u8d77\u6765\uff0c\u7136\u540e\u5c31\u53ef\u4ee5\u53bb\u6267\u884c\u4e00\u4e9b\u532a\u5937\u6240\u601d\u7684\u4efb\u52a1\u3002\u8d5e\u53f9<\/p>","protected":false},"excerpt":{"rendered":"<p>\u7f18\u8d77\uff1a\u516c\u53f8\u670d\u52a1\u5668\u4e0a\u6570\u636e\u5e93\u8d8a\u6765\u8d8a\u5927\uff0c\u4ee5\u524d\u5907\u4efd\u6570\u636e\u65f6\u5c06\u6570\u636e\u5e93\u6574\u4e2adump\u51fa\u6765\uff0c\u7136\u540e\u7528tar czvf\u538b\u7f29\u5907\u4efd\uff0c\u8fd8\u539f\u65f6\u7528tar zxvf\u89e3\u538b\u7f29\uff0c\u6bcf\u6b21\u90fd\u4f5c\u8fd9\u79cd\u4e8b\u60c5\u7684\u786e\u5f88\u70e6\u3002 \u6d4f\u89c8PostgreSQL\u6587\u6863\u65f6\uff0c\u770b&#46;&#46;&#46;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,340,101],"tags":[452,453],"class_list":["post-1420","post","type-post","status-publish","format-standard","hentry","category-linux","category-mac-os","category-db","tag-gzip","tag-453"],"_links":{"self":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=1420"}],"version-history":[{"count":1,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1420\/revisions"}],"predecessor-version":[{"id":1422,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1420\/revisions\/1422"}],"wp:attachment":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=1420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=1420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=1420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}