{"id":3314,"date":"2018-01-09T08:35:02","date_gmt":"2018-01-09T13:35:02","guid":{"rendered":"https:\/\/www.pair.com\/support\/kb\/?p=3314"},"modified":"2023-08-04T13:49:09","modified_gmt":"2023-08-04T17:49:09","slug":"exporting-a-database-via-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/","title":{"rendered":"Exporting a Database via phpMyAdmin"},"content":{"rendered":"\n<p><span style=\"font-weight: 400;\">You can export your database from phpMyAdmin. If you need help accessing the database from the phpMyAdmin within the Account Control Center, see our article, <\/span><a href=\"https:\/\/www.pair.com\/support\/kb\/using-phpmyadmin\/\"><span style=\"font-weight: 400;\">Accessing phpMyAdmin in the ACC<\/span><\/a><span style=\"font-weight: 400;\">. <\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Exporting a Database from phpMyAdmin<\/h3>\n\n\n\n<ol>\n<li><span style=\"font-weight: 400;\">Log into your phpMyAdmin account where the database is located<\/span><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">In the top navbar, click the <\/span><b>Export<\/b><span style=\"font-weight: 400;\"> tab<a href=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3315\" src=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export.png\" alt=\"Export button image\" width=\"662\" height=\"46\" srcset=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export.png 662w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-300x21.png 300w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-60x4.png 60w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-150x10.png 150w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/a><\/span><\/li>\n\n\n\n<li>On the Export page, select your <b>Export Method<a href=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-method.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3316\" src=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-method.png\" alt=\"image of export image\" width=\"662\" height=\"105\" srcset=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-method.png 662w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-method-300x48.png 300w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-method-60x10.png 60w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export-method-150x24.png 150w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/a><\/b>\n<ul>\n<li><b>Custom<\/b><span style=\"font-weight: 400;\">: This allows you to customize the export process. You can select the export output, format, and more. The options for Custom Export will appear beneath the <\/span><b>Format<\/b><span style=\"font-weight: 400;\"> section. <\/span><\/li>\n\n\n\n<li><b>Quick<\/b><span style=\"font-weight: 400;\">: This uses the default settings to export the entirety of your database<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">Once you have selected your export method, select the <\/span><b>Format<\/b><span style=\"font-weight: 400;\"> type. If you\u2019re unsure what to choose, we recommend using SQL<a href=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/format.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3317\" src=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/format.png\" alt=\"image of format dropdown\" width=\"662\" height=\"108\" srcset=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/format.png 662w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/format-300x49.png 300w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/format-60x10.png 60w, https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/format-150x24.png 150w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/a><\/span><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">If you selected the <\/span><b>Custom <\/b><span style=\"font-weight: 400;\">export method, customize your export with the available options below the <\/span><b>Format <\/b><span style=\"font-weight: 400;\">section <\/span><\/li>\n\n\n\n<li><span style=\"font-weight: 400;\">When finished, click <\/span><b>Go<\/b><\/li>\n<\/ol>\n\n\n\n<p><span style=\"font-weight: 400;\">Your database will be exported, then downloaded in your browser. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can export your database from phpMyAdmin. If you need help accessing the database from the phpMyAdmin within the Account Control Center, see our article, Accessing phpMyAdmin in the ACC. Exporting a Database from phpMyAdmin Your database will be exported, then downloaded in your browser.<\/p>\n","protected":false},"author":11,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[34],"ht-kb-tag":[186],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exporting a Database via phpMyAdmin - Knowledge Base - Pair Networks<\/title>\n<meta name=\"description\" content=\"Learn how to export your database from phpMyAdmin. By following this process, the database will be exported and downloaded in your browser.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporting a Database via phpMyAdmin - Knowledge Base - Pair Networks\" \/>\n<meta property=\"og:description\" content=\"Learn how to export your database from phpMyAdmin. By following this process, the database will be exported and downloaded in your browser.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - Pair Networks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pairnetworks\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-04T17:49:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@pairNetworks\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/\",\"name\":\"Exporting a Database via phpMyAdmin - Knowledge Base - Pair Networks\",\"isPartOf\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#website\"},\"datePublished\":\"2018-01-09T13:35:02+00:00\",\"dateModified\":\"2023-08-04T17:49:09+00:00\",\"description\":\"Learn how to export your database from phpMyAdmin. By following this process, the database will be exported and downloaded in your browser.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pair.com\/support\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exporting a Database via phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#website\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/\",\"name\":\"Knowledge Base - Pair Networks\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pair.com\/support\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#organization\",\"name\":\"Pair Networks\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg\",\"contentUrl\":\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg\",\"width\":360,\"height\":360,\"caption\":\"Pair Networks\"},\"image\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/pairnetworks\/\",\"https:\/\/twitter.com\/pairNetworks\",\"https:\/\/www.instagram.com\/pairnetworks\/\",\"https:\/\/www.linkedin.com\/company\/2269676\/\",\"https:\/\/www.pinterest.com\/pairnetworksinc\/pins\/\",\"https:\/\/www.youtube.com\/user\/pairnetworks\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exporting a Database via phpMyAdmin - Knowledge Base - Pair Networks","description":"Learn how to export your database from phpMyAdmin. By following this process, the database will be exported and downloaded in your browser.","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:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"Exporting a Database via phpMyAdmin - Knowledge Base - Pair Networks","og_description":"Learn how to export your database from phpMyAdmin. By following this process, the database will be exported and downloaded in your browser.","og_url":"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/","og_site_name":"Knowledge Base - Pair Networks","article_publisher":"https:\/\/www.facebook.com\/pairnetworks\/","article_modified_time":"2023-08-04T17:49:09+00:00","og_image":[{"url":"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2018\/01\/export.png"}],"twitter_card":"summary_large_image","twitter_site":"@pairNetworks","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/","url":"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/","name":"Exporting a Database via phpMyAdmin - Knowledge Base - Pair Networks","isPartOf":{"@id":"https:\/\/www.pair.com\/support\/kb\/#website"},"datePublished":"2018-01-09T13:35:02+00:00","dateModified":"2023-08-04T17:49:09+00:00","description":"Learn how to export your database from phpMyAdmin. By following this process, the database will be exported and downloaded in your browser.","breadcrumb":{"@id":"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pair.com\/support\/kb\/exporting-a-database-via-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pair.com\/support\/kb\/"},{"@type":"ListItem","position":2,"name":"Exporting a Database via phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/www.pair.com\/support\/kb\/#website","url":"https:\/\/www.pair.com\/support\/kb\/","name":"Knowledge Base - Pair Networks","description":"","publisher":{"@id":"https:\/\/www.pair.com\/support\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pair.com\/support\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.pair.com\/support\/kb\/#organization","name":"Pair Networks","url":"https:\/\/www.pair.com\/support\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg","contentUrl":"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg","width":360,"height":360,"caption":"Pair Networks"},"image":{"@id":"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pairnetworks\/","https:\/\/twitter.com\/pairNetworks","https:\/\/www.instagram.com\/pairnetworks\/","https:\/\/www.linkedin.com\/company\/2269676\/","https:\/\/www.pinterest.com\/pairnetworksinc\/pins\/","https:\/\/www.youtube.com\/user\/pairnetworks"]}]}},"_links":{"self":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/3314"}],"collection":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/comments?post=3314"}],"version-history":[{"count":5,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/3314\/revisions"}],"predecessor-version":[{"id":9321,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/3314\/revisions\/9321"}],"wp:attachment":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/media?parent=3314"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=3314"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=3314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}