{"id":3222,"date":"2019-12-24T09:00:00","date_gmt":"2019-12-24T17:00:00","guid":{"rendered":"https:\/\/ml2solutions.com\/?p=3222"},"modified":"2021-05-02T17:07:04","modified_gmt":"2021-05-03T00:07:04","slug":"database-backup-using-wp-cli","status":"publish","type":"post","link":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/","title":{"rendered":"Database backup using WP-CLI"},"content":{"rendered":"\n<p>I don&#8217;t recall what triggered the need to find another way to backup a WordPress database, but I recalled seeing something about a command line option in WordPress.  I did some research and found this article ( https:\/\/www.liquidweb.com\/kb\/backup-wordpress-database-wp-cli\/ ). <\/p>\n\n\n\n<p>What are interesting about WP-CLI is the simple syntax.  To backup from a SSH command prompt, the command is &#8220;wp db export&#8221;.<\/p>\n\n\n\n<p>Please simple.  ;-)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I don&#8217;t recall what triggered the need to find another way to backup a WordPress database, but I recalled seeing something about a command line option in WordPress. I did [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":3223,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[21],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database backup using WP-CLI - ML2 Solutions<\/title>\n<meta name=\"description\" content=\"Database backup using WP-CLI I don&#039;t recall what triggered the need to find another way to backup a WordPress database, but I recalled seeing something about a command line option in\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database backup using WP-CLI - ML2 Solutions\" \/>\n<meta property=\"og:description\" content=\"Database backup using WP-CLI I don&#039;t recall what triggered the need to find another way to backup a WordPress database, but I recalled seeing something about a command line option in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/\" \/>\n<meta property=\"og:site_name\" content=\"ML2 Solutions\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ml2solutions\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ml2solutions\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-24T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-03T00:07:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"1335\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Matt Woicik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ml2solutions\" \/>\n<meta name=\"twitter:site\" content=\"@ml2solutions\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matt Woicik\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/\"},\"author\":{\"name\":\"Matt Woicik\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd\"},\"headline\":\"Database backup using WP-CLI\",\"datePublished\":\"2019-12-24T17:00:00+00:00\",\"dateModified\":\"2021-05-03T00:07:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/\"},\"wordCount\":72,\"publisher\":{\"@id\":\"https:\/\/ml2solutions.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg\",\"keywords\":[\"WordPress\"],\"articleSection\":[\"Websites\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/\",\"url\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/\",\"name\":\"Database backup using WP-CLI - ML2 Solutions\",\"isPartOf\":{\"@id\":\"https:\/\/ml2solutions.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg\",\"datePublished\":\"2019-12-24T17:00:00+00:00\",\"dateModified\":\"2021-05-03T00:07:04+00:00\",\"description\":\"Database backup using WP-CLI I don't recall what triggered the need to find another way to backup a WordPress database, but I recalled seeing something about a command line option in\",\"breadcrumb\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#primaryimage\",\"url\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg\",\"contentUrl\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg\",\"width\":2000,\"height\":1335,\"caption\":\"Old school floppy disk drive data storage\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ml2solutions.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Websites\",\"item\":\"https:\/\/ml2solutions.com\/category\/websites\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Database backup using WP-CLI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ml2solutions.com\/#website\",\"url\":\"https:\/\/ml2solutions.com\/\",\"name\":\"ML2 Solutions\",\"description\":\"Helping you get more leads and make more sales\",\"publisher\":{\"@id\":\"https:\/\/ml2solutions.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ml2solutions.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ml2solutions.com\/#organization\",\"name\":\"ML2 Solutions\",\"url\":\"https:\/\/ml2solutions.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png\",\"contentUrl\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png\",\"width\":303,\"height\":54,\"caption\":\"ML2 Solutions\"},\"image\":{\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ml2solutions\",\"https:\/\/x.com\/ml2solutions\",\"https:\/\/www.instagram.com\/ml2solutions\/\",\"https:\/\/www.pinterest.com\/ml2solutions\/\",\"https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd\",\"name\":\"Matt Woicik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g\",\"caption\":\"Matt Woicik\"},\"description\":\"Matt is a digital marketing strategist and the owner of ML2 Solutions, a digital marketing agency. He helps businesses increase awareness and get more leads using digital marketing. New marketing methods are confusing, always changing and difficult to figure out. Matt helps to explain things and provide solutions with clear results.\",\"sameAs\":[\"https:\/\/ml2solutions.com\",\"https:\/\/www.facebook.com\/ml2solutions\",\"https:\/\/www.instagram.com\/ml2solutions\/\",\"https:\/\/www.linkedin.com\/company\/ml2solutions\/\",\"https:\/\/www.pinterest.com\/ml2solutions\/\",\"https:\/\/x.com\/ml2solutions\",\"https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database backup using WP-CLI - ML2 Solutions","description":"Database backup using WP-CLI I don't recall what triggered the need to find another way to backup a WordPress database, but I recalled seeing something about a command line option in","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:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/","og_locale":"en_US","og_type":"article","og_title":"Database backup using WP-CLI - ML2 Solutions","og_description":"Database backup using WP-CLI I don't recall what triggered the need to find another way to backup a WordPress database, but I recalled seeing something about a command line option in","og_url":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/","og_site_name":"ML2 Solutions","article_publisher":"https:\/\/www.facebook.com\/ml2solutions","article_author":"https:\/\/www.facebook.com\/ml2solutions","article_published_time":"2019-12-24T17:00:00+00:00","article_modified_time":"2021-05-03T00:07:04+00:00","og_image":[{"width":2000,"height":1335,"url":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg","type":"image\/jpeg"}],"author":"Matt Woicik","twitter_card":"summary_large_image","twitter_creator":"@ml2solutions","twitter_site":"@ml2solutions","twitter_misc":{"Written by":"Matt Woicik"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#article","isPartOf":{"@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/"},"author":{"name":"Matt Woicik","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd"},"headline":"Database backup using WP-CLI","datePublished":"2019-12-24T17:00:00+00:00","dateModified":"2021-05-03T00:07:04+00:00","mainEntityOfPage":{"@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/"},"wordCount":72,"publisher":{"@id":"https:\/\/ml2solutions.com\/#organization"},"image":{"@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#primaryimage"},"thumbnailUrl":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg","keywords":["WordPress"],"articleSection":["Websites"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/","url":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/","name":"Database backup using WP-CLI - ML2 Solutions","isPartOf":{"@id":"https:\/\/ml2solutions.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#primaryimage"},"image":{"@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#primaryimage"},"thumbnailUrl":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg","datePublished":"2019-12-24T17:00:00+00:00","dateModified":"2021-05-03T00:07:04+00:00","description":"Database backup using WP-CLI I don't recall what triggered the need to find another way to backup a WordPress database, but I recalled seeing something about a command line option in","breadcrumb":{"@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#primaryimage","url":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg","contentUrl":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2019\/12\/old-school-floppy-disk-drive-data-storage.jpg","width":2000,"height":1335,"caption":"Old school floppy disk drive data storage"},{"@type":"BreadcrumbList","@id":"https:\/\/ml2solutions.com\/websites\/database-backup-using-wp-cli\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ml2solutions.com\/"},{"@type":"ListItem","position":2,"name":"Websites","item":"https:\/\/ml2solutions.com\/category\/websites\/"},{"@type":"ListItem","position":3,"name":"Database backup using WP-CLI"}]},{"@type":"WebSite","@id":"https:\/\/ml2solutions.com\/#website","url":"https:\/\/ml2solutions.com\/","name":"ML2 Solutions","description":"Helping you get more leads and make more sales","publisher":{"@id":"https:\/\/ml2solutions.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ml2solutions.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ml2solutions.com\/#organization","name":"ML2 Solutions","url":"https:\/\/ml2solutions.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/","url":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png","contentUrl":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png","width":303,"height":54,"caption":"ML2 Solutions"},"image":{"@id":"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ml2solutions","https:\/\/x.com\/ml2solutions","https:\/\/www.instagram.com\/ml2solutions\/","https:\/\/www.pinterest.com\/ml2solutions\/","https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA"]},{"@type":"Person","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd","name":"Matt Woicik","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g","caption":"Matt Woicik"},"description":"Matt is a digital marketing strategist and the owner of ML2 Solutions, a digital marketing agency. He helps businesses increase awareness and get more leads using digital marketing. New marketing methods are confusing, always changing and difficult to figure out. Matt helps to explain things and provide solutions with clear results.","sameAs":["https:\/\/ml2solutions.com","https:\/\/www.facebook.com\/ml2solutions","https:\/\/www.instagram.com\/ml2solutions\/","https:\/\/www.linkedin.com\/company\/ml2solutions\/","https:\/\/www.pinterest.com\/ml2solutions\/","https:\/\/x.com\/ml2solutions","https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA"]}]}},"_links":{"self":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts\/3222"}],"collection":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/comments?post=3222"}],"version-history":[{"count":0,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts\/3222\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/media\/3223"}],"wp:attachment":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/media?parent=3222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/categories?post=3222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/tags?post=3222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}