{"id":1719,"date":"2021-09-07T14:01:25","date_gmt":"2021-09-07T14:01:25","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=1719"},"modified":"2021-09-07T14:01:25","modified_gmt":"2021-09-07T14:01:25","slug":"backup-database-from-phpmyadmin","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/backup-database-from-phpmyadmin\/","title":{"rendered":"Backup Database from PHPMyAdmin"},"content":{"rendered":"<p>You are able to backup databases in different variety of ways, one in all that is via the Backup Facility with cPanel however there are different alternatives to <strong>Backup MySQL databases<\/strong> without the requirement of that facility on its own. you&#8217;ll backup via phpMyAdmin within the Export section of the facility. Rather like the backup facility in cPanel, it will provide backups to you as a .tar.gz format which suggests you\u2019ll be ready to restore it via the cPanel facility if you would like to try to do so.<br \/>\n\u2022 Once you\u2019ve accessed the <strong>phpMyAdmin<\/strong> facility enter into the database (empty or otherwise) and from the top menu click Export.<br \/>\n\u2022 Scroll down on page till you get to a \u2018Save as file\u2019 option and choose \u2018gzipped\u2019 and leave the settings as default.<br \/>\n\u2022 Click \u2018Go\u2019<\/p>\n<p>To restore via the phpMyAdmin facility unfortunately you\u2019ll already required the database setup to restore the inner contents, like the tables, etc. thus create a rnew database (name it as equivalent because the database name that you backed up previously). Once you\u2019ve created the database and you\u2019re within it, from the top menu again click Import.<br \/>\n\u2022 Now choose \u2018Browse\u2019 and search the relevant gzipped file, and leave all settings as default.<\/p>\n<p>If all goes well you will see the contents of the database all there. keep in mind rather like the cPanel backup facility, if you use usernames for every database you\u2019ll required to set that up separately, for example if you restored the backup via the cPanel facility. Ensure you re-connect the username and database along.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You are able to backup databases in different variety of ways, one in all that is via the Backup Facility with cPanel however there are different alternatives to Backup MySQL databases without the requirement of that facility on its own. you&#8217;ll backup via phpMyAdmin within the Export section of the facility. Rather like the backup [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1719","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Backup Database from 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\/backup-database-from-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup Database from PHPMyAdmin - OWS KB\" \/>\n<meta property=\"og:description\" content=\"You are able to backup databases in different variety of ways, one in all that is via the Backup Facility with cPanel however there are different alternatives to Backup MySQL databases without the requirement of that facility on its own. you&#8217;ll backup via phpMyAdmin within the Export section of the facility. Rather like the backup [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/backup-database-from-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-07T14:01:25+00:00\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/backup-database-from-phpmyadmin\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/backup-database-from-phpmyadmin\/\",\"name\":\"Backup Database from PHPMyAdmin - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"datePublished\":\"2021-09-07T14:01:25+00:00\",\"dateModified\":\"2021-09-07T14:01:25+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/backup-database-from-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/backup-database-from-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/backup-database-from-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\/backup-database-from-phpmyadmin\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/backup-database-from-phpmyadmin\/\",\"name\":\"Backup Database from 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\/1719","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=1719"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1719\/revisions"}],"predecessor-version":[{"id":1720,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1719\/revisions\/1720"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=1719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=1719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=1719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}