{"id":185,"date":"2022-08-23T09:17:34","date_gmt":"2022-08-23T03:17:34","guid":{"rendered":"https:\/\/bytegeeks.net\/blog\/?p=185"},"modified":"2022-08-23T09:17:39","modified_gmt":"2022-08-23T03:17:39","slug":"taking-bookstack-db-backup-in-docker","status":"publish","type":"post","link":"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/","title":{"rendered":"Taking bookstack DB backup in docker"},"content":{"rendered":"\n<p>Taking bookstack DB backup in docker in very straight forward. Copy this one line code, modify the necessary details, copy the modified code, paste it in terminal of the ssh session and BOOM! You are done with taking bookstack DB backup in docker.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\" data-show-lang=\"1\"><code>sudo docker exec bookstack_db \/usr\/bin\/mysqldump --user bookstack --password=bookstack bookstackapp &gt; \/home\/bytegeek\/bookstack_db.sql<\/code><\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Breakdown of the above command<\/h4>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"is-style-plain wp-block-list\"><li><code>sudo docker exec bookstack_db \/usr\/bin\/mysqldump<\/code>  specifies the container name and in-app aka virtual directory location.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><code>--user bookstack<\/code>   specifies the user authorized to take backup.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><code>--password=bookstack<\/code>   specifies the password to authenticate the user, replace the password accordingly.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><code>bookstackapp > \/home\/bytegeek\/bookstack_db.sql<\/code>   specifies the location of the output file. This is the location from where you will recover the output file.<\/li><\/ul>\n\n\n\n<p>There you go, if you didn&#8217;t know, now you know! To explore more visit the <a href=\"https:\/\/bytegeeks.net\/blog\">homepage&#8230;<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Taking bookstack DB backup in docker in very straight forward. Copy this one line code, modify the necessary details, copy the modified code, paste it in terminal of the ssh session and BOOM! You are done with taking bookstack DB backup in docker. Breakdown of the above command sudo docker exec bookstack_db \/usr\/bin\/mysqldump specifies the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12],"tags":[20,21],"class_list":["post-185","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-bookstack","tag-docker"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Taking bookstack DB backup in docker - ByteGeeks<\/title>\n<meta name=\"description\" content=\"One liner to taking bookstack DB (database) backup in docker. Learn the command and explanation here now.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Taking bookstack DB backup in docker - ByteGeeks\" \/>\n<meta property=\"og:description\" content=\"One liner to taking bookstack DB (database) backup in docker. Learn the command and explanation here now.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/\" \/>\n<meta property=\"og:site_name\" content=\"ByteGeeks\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-23T03:17:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-23T03:17:39+00:00\" \/>\n<meta name=\"author\" content=\"Redwan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Redwan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/\",\"url\":\"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/\",\"name\":\"Taking bookstack DB backup in docker - ByteGeeks\",\"isPartOf\":{\"@id\":\"https:\/\/bytegeeks.net\/blog\/#website\"},\"datePublished\":\"2022-08-23T03:17:34+00:00\",\"dateModified\":\"2022-08-23T03:17:39+00:00\",\"author\":{\"@id\":\"https:\/\/bytegeeks.net\/blog\/#\/schema\/person\/419ede240aa968b3bf8202cf9e94e792\"},\"description\":\"One liner to taking bookstack DB (database) backup in docker. Learn the command and explanation here now.\",\"breadcrumb\":{\"@id\":\"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bytegeeks.net\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Taking bookstack DB backup in docker\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bytegeeks.net\/blog\/#website\",\"url\":\"https:\/\/bytegeeks.net\/blog\/\",\"name\":\"ByteGeeks\",\"description\":\"Your one-stop shop for everything IT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bytegeeks.net\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bytegeeks.net\/blog\/#\/schema\/person\/419ede240aa968b3bf8202cf9e94e792\",\"name\":\"Redwan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bytegeeks.net\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/785ee4165b07a924d3e8538e8fd845bbd1d22e2680c18ebb16aa54890455e008?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/785ee4165b07a924d3e8538e8fd845bbd1d22e2680c18ebb16aa54890455e008?s=96&d=mm&r=g\",\"caption\":\"Redwan\"},\"description\":\"Just your average IT guy talking about IT stuff.\",\"sameAs\":[\"https:\/\/bytegeeks.net\/blog\"],\"url\":\"https:\/\/bytegeeks.net\/blog\/author\/redmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Taking bookstack DB backup in docker - ByteGeeks","description":"One liner to taking bookstack DB (database) backup in docker. Learn the command and explanation here now.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/","og_locale":"en_US","og_type":"article","og_title":"Taking bookstack DB backup in docker - ByteGeeks","og_description":"One liner to taking bookstack DB (database) backup in docker. Learn the command and explanation here now.","og_url":"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/","og_site_name":"ByteGeeks","article_published_time":"2022-08-23T03:17:34+00:00","article_modified_time":"2022-08-23T03:17:39+00:00","author":"Redwan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Redwan","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/","url":"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/","name":"Taking bookstack DB backup in docker - ByteGeeks","isPartOf":{"@id":"https:\/\/bytegeeks.net\/blog\/#website"},"datePublished":"2022-08-23T03:17:34+00:00","dateModified":"2022-08-23T03:17:39+00:00","author":{"@id":"https:\/\/bytegeeks.net\/blog\/#\/schema\/person\/419ede240aa968b3bf8202cf9e94e792"},"description":"One liner to taking bookstack DB (database) backup in docker. Learn the command and explanation here now.","breadcrumb":{"@id":"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bytegeeks.net\/blog\/taking-bookstack-db-backup-in-docker\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bytegeeks.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Taking bookstack DB backup in docker"}]},{"@type":"WebSite","@id":"https:\/\/bytegeeks.net\/blog\/#website","url":"https:\/\/bytegeeks.net\/blog\/","name":"ByteGeeks","description":"Your one-stop shop for everything IT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bytegeeks.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/bytegeeks.net\/blog\/#\/schema\/person\/419ede240aa968b3bf8202cf9e94e792","name":"Redwan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bytegeeks.net\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/785ee4165b07a924d3e8538e8fd845bbd1d22e2680c18ebb16aa54890455e008?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/785ee4165b07a924d3e8538e8fd845bbd1d22e2680c18ebb16aa54890455e008?s=96&d=mm&r=g","caption":"Redwan"},"description":"Just your average IT guy talking about IT stuff.","sameAs":["https:\/\/bytegeeks.net\/blog"],"url":"https:\/\/bytegeeks.net\/blog\/author\/redmin\/"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/posts\/185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":16,"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions"}],"predecessor-version":[{"id":216,"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions\/216"}],"wp:attachment":[{"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/media?parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/categories?post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bytegeeks.net\/blog\/wp-json\/wp\/v2\/tags?post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}