{"id":1812,"date":"2021-09-11T11:25:53","date_gmt":"2021-09-11T11:25:53","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=1812"},"modified":"2021-09-11T11:32:17","modified_gmt":"2021-09-11T11:32:17","slug":"how-to-take-mysql-backups-with-phpmyadmin","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/","title":{"rendered":"How to take MySQL backups with phpMyAdmin"},"content":{"rendered":"<p>The phpMyAdmin option may be used to backup all databases on a server that has limited MySQL disk usage. This has the extra advantage of serving to you download the database backup from the server itself.<\/p>\n<p>To start with, follow the steps as shown below:<\/p>\n<p>1. Log in to <strong>WHM<\/strong> as the root user using login details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1814\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-1-266x300.png\" alt=\"bk-1\" width=\"345\" height=\"389\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-1-266x300.png 266w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-1.png 345w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/p>\n<p>2. Once you have got logged in, you&#8217;ll be able to see a search icon. A drop-down list are displayed on your screen after you search for <strong>SQL Services<\/strong>. choose <strong>phpMyAdmin<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1815\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-2-300x120.png\" alt=\"bk-2\" width=\"1024\" height=\"411\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-2-300x120.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-2-768x308.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-2.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>3. This screen will appear after you selected <strong>phpMyAdmin<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1816\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-3-300x204.png\" alt=\"bk-3\" width=\"654\" height=\"444\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-3-300x204.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-3.png 654w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/p>\n<p>4. Choose the <strong>database(s)<\/strong> for which you needed to backup.<\/p>\n<ul>\n<li>Select the individual database that you want to backup.<\/li>\n<li>Select nothing to back up all databases.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1817\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-4-300x121.png\" alt=\"bk-4\" width=\"661\" height=\"267\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-4-300x121.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-4.png 661w\" sizes=\"auto, (max-width: 661px) 100vw, 661px\" \/><\/p>\n<p>5. Then click on the <strong>Export<\/strong> button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1818\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-5-300x211.png\" alt=\"bk-5\" width=\"646\" height=\"455\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-5-300x211.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-5.png 646w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><\/p>\n<p><strong>Note<\/strong>: you may be unable to back up MySQL system tables using this method. Instead, choose the MySQL database in phpMyAdmin, and so Export to generate with a backup. phpMyAdmin may export in many different formats at the side of varied customizations. Make sure that an uncompressed backup is generated by the default settings using the .sql extension.<\/p>\n<p>6. In the Format section Select <strong>SQL<\/strong>.<\/p>\n<p>7. Then click on <strong>Go<\/strong>.<\/p>\n<p>In this way by following the above steps, you can take MySQL backups with phpMyAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The phpMyAdmin option may be used to backup all databases on a server that has limited MySQL disk usage. This has the extra advantage of serving to you download the database backup from the server itself. To start with, follow the steps as shown below: 1. Log in to WHM as the root user using [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"class_list":["post-1812","post","type-post","status-publish","format-standard","hentry","category-web-hosting"],"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 take MySQL backups with phpMyAdmin - 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-take-mysql-backups-with-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to take MySQL backups with phpMyAdmin - OWS KB\" \/>\n<meta property=\"og:description\" content=\"The phpMyAdmin option may be used to backup all databases on a server that has limited MySQL disk usage. This has the extra advantage of serving to you download the database backup from the server itself. To start with, follow the steps as shown below: 1. Log in to WHM as the root user using [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-11T11:25:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-11T11:32:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-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-take-mysql-backups-with-phpmyadmin\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/bk-1.png\",\"width\":345,\"height\":389,\"caption\":\"bk-1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/\",\"name\":\"How to take MySQL backups with phpMyAdmin - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/#primaryimage\"},\"datePublished\":\"2021-09-11T11:25:53+00:00\",\"dateModified\":\"2021-09-11T11:32:17+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/#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-take-mysql-backups-with-phpmyadmin\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-take-mysql-backups-with-phpmyadmin\/\",\"name\":\"How to take MySQL backups with phpMyAdmin\"}}]},{\"@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\/1812","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=1812"}],"version-history":[{"count":3,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1812\/revisions"}],"predecessor-version":[{"id":1819,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1812\/revisions\/1819"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=1812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=1812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=1812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}