{"id":1988,"date":"2014-09-11T14:42:43","date_gmt":"2014-09-11T14:42:43","guid":{"rendered":"http:\/\/blog.designed79.co.uk\/?p=1988"},"modified":"2014-09-14T20:04:08","modified_gmt":"2014-09-14T20:04:08","slug":"using-gzip-and-gunzip-with-mysql-to-import-export-backups","status":"publish","type":"post","link":"https:\/\/blog.designed79.co.uk\/?p=1988","title":{"rendered":"Using Gzip And Gunzip With Mysql To Import &#038; Export Backups"},"content":{"rendered":"<p>I used that technique in the past, but had forgotten the exact syntax of the one liners. So let\u2019s say you don\u2019t have enough storage on your partition to have both the SQL dump and the actual data, you can import it or export it directly from the compressed file.<\/p>\n<p>Exporting:<\/p>\n<div class=\"codecolorer-container text default\" style=\"overflow:auto;white-space:nowrap;\"><div class=\"text codecolorer\">mysqldump -u user -p database | gzip &gt; database.sql.gz<\/div><\/div>\n<p>Importing:<\/p>\n<div class=\"codecolorer-container text default\" style=\"overflow:auto;white-space:nowrap;\"><div class=\"text codecolorer\">gunzip &lt; database.sql.gz | mysql -u user -p database<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I used that technique in the past, but had forgotten the exact syntax of the one liners. So let\u2019s say you don\u2019t [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1988","post","type-post","status-publish","format-standard","hentry","category-info-on-tech"],"_links":{"self":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1988"}],"version-history":[{"count":0,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1988\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}