{"id":128,"date":"2021-08-03T10:52:34","date_gmt":"2021-08-03T10:52:34","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=128"},"modified":"2021-08-03T10:52:34","modified_gmt":"2021-08-03T10:52:34","slug":"how-to-enable-mysql-database-backups-in-whm","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/","title":{"rendered":"How to enable MySQL database backups in WHM"},"content":{"rendered":"<p>This tutorial will assist you to understand and follow the method for enabling <strong>MySQL database<\/strong> safeguards in WHM. you&#8217;ll follow these simple steps to create <strong>MySQL database backups<\/strong>.<\/p>\n<p>1. Log into WHM.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1148\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-1-266x300.png\" alt=\"data-1\" width=\"345\" height=\"389\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-1-266x300.png 266w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-1.png 345w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/p>\n<p>2. Once you\u2019ve logged in, navigate to <strong>Backup Configuration<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1149\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-2-300x120.png\" alt=\"data-2\" width=\"554\" height=\"222\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-2-300x120.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-2.png 554w\" sizes=\"auto, (max-width: 554px) 100vw, 554px\" \/><\/p>\n<p>3. Under Back up SQL Databases within the Databases section, choose one among the following options:<\/p>\n<p>\u2022 <strong>Per Account Only<\/strong>: This selection can use mysqldumpback to form backups for each individual cPanel account.<\/p>\n<p>\u2022 <strong>Entire MySQL Directory:<\/strong> This option can use the <strong>\/var\/lib\/MySQL\/<\/strong> directory to form backups of all the databases on the server.<\/p>\n<p>Per Account and whole MySQL Directory: This selection can create copies of all databases on the server from the \/var\/lib\/MySQL\/ directory, as well as, each individual cPanel account.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1150\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-3-300x116.png\" alt=\"data-3\" width=\"738\" height=\"286\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-3-300x116.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-3.png 738w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><\/p>\n<p>4. Select save <strong>configuration<\/strong>.<\/p>\n<p>In this method, you&#8217;ll simply enable MySQL database backup in WHM. Simply make sure that you backup your database along with the websites. If you have got any queries, please contact our technical support team 24\/7 and visit our Knowledgebase to know more.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial will assist you to understand and follow the method for enabling MySQL database safeguards in WHM. you&#8217;ll follow these simple steps to create MySQL database backups. 1. Log into WHM. 2. Once you\u2019ve logged in, navigate to Backup Configuration. 3. Under Back up SQL Databases within the Databases section, choose one among the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-128","post","type-post","status-publish","format-standard","hentry","category-whm"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to enable MySQL database backups in WHM - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to enable MySQL database backups in WHM - OWS KB\" \/>\n<meta property=\"og:description\" content=\"This tutorial will assist you to understand and follow the method for enabling MySQL database safeguards in WHM. you&#8217;ll follow these simple steps to create MySQL database backups. 1. Log into WHM. 2. Once you\u2019ve logged in, navigate to Backup Configuration. 3. Under Back up SQL Databases within the Databases section, choose one among the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-03T10:52:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-1-266x300.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\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\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/06\/data-1.png\",\"width\":345,\"height\":389,\"caption\":\"data-1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/\",\"name\":\"How to enable MySQL database backups in WHM - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/#primaryimage\"},\"datePublished\":\"2021-08-03T10:52:34+00:00\",\"dateModified\":\"2021-08-03T10:52:34+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-enable-mysql-database-backups-in-whm\/\",\"name\":\"How to enable MySQL database backups in WHM\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/128\/revisions"}],"predecessor-version":[{"id":1151,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/128\/revisions\/1151"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}