{"id":906,"date":"2016-02-20T08:16:10","date_gmt":"2016-02-20T13:16:10","guid":{"rendered":"http:\/\/xfloyd.net\/blog\/?p=906"},"modified":"2018-01-08T19:04:18","modified_gmt":"2018-01-09T00:04:18","slug":"unzip-bz2-backup-straight-to-mysql","status":"publish","type":"post","link":"https:\/\/xfloyd.net\/blog\/?p=906","title":{"rendered":"Backup and Restore compressed MySQL databases using gz or bz2"},"content":{"rendered":"<p><strong>Backup<\/strong><br \/>\n<code><br \/>\nmysqldump --routines -u root -p --databases db1 db2 db3 | gzip &gt; \/var\/www\/backups\/mysql\/databases.sql.gz # multiple db using gzip<br \/>\nmysqldump --routines -u root -p --databases db1 db2 db3 | bzip2 &gt; \/var\/www\/backups\/mysql\/databases.sql.bz2 # multiple db using bz2<\/p>\n<p>mysqldump --routines -u root -p db1 | gzip &gt; \/var\/www\/backups\/mysql\/db1.sql.bz2 # single db using gzip<br \/>\nmysqldump --routines -u root -p db1 | bzip2 &gt; \/var\/www\/backups\/mysql\/db1.sql.bz2 # single db using bz2<br \/>\n<\/code><\/p>\n<p><strong>Restore<\/strong><br \/>\n<code><br \/>\nbunzip2 &lt; db1.sql.bz2 | mysql -u root -p db1<br \/>\nzcat db1.sql.gz | mysql -u root -p db1<br \/>\n<\/code><\/p>\n<p>Same goes for multiple DBs just add one or more DB to restore at the end of the command, or leave blank to restore all.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Backup mysqldump &#8211;routines -u root -p &#8211;databases db1 db2 db3 | gzip &gt; \/var\/www\/backups\/mysql\/databases.sql.gz # multiple db using gzip mysqldump &#8211;routines -u root -p &#8211;databases db1 db2 db3 | bzip2 &gt; \/var\/www\/backups\/mysql\/databases.sql.bz2 # multiple db using bz2 mysqldump &#8211;routines -u root -p db1 | gzip &gt; \/var\/www\/backups\/mysql\/db1.sql.bz2 # single db using gzip mysqldump &#8211;routines -u [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/906"}],"collection":[{"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=906"}],"version-history":[{"count":7,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/906\/revisions"}],"predecessor-version":[{"id":1074,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/906\/revisions\/1074"}],"wp:attachment":[{"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}