{"id":6708,"date":"2022-05-23T08:47:45","date_gmt":"2022-05-23T08:47:45","guid":{"rendered":"https:\/\/wpx.net\/kb\/?post_type=ht_kb&#038;p=6708"},"modified":"2025-07-21T06:59:50","modified_gmt":"2025-07-21T06:59:50","slug":"how-can-i-export-a-database","status":"publish","type":"ht_kb","link":"https:\/\/wpx.net\/kb\/how-can-i-export-a-database\/","title":{"rendered":"How can I export a database?"},"content":{"rendered":"\n<p>In this article, you&#8217;ll learn how to export a database using <strong>phpMyAdmin<\/strong> in your WPX hosting account.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1-login-to-your-wpx-account\">Step 1. Log in to your WPX account<\/h2>\n\n\n\n<p>Begin by logging into your WPX account. You can do this by visiting the <strong><a href=\"https:\/\/wpx.net\/clientarea\/\" target=\"_blank\" rel=\"noreferrer noopener\">WPX login page<\/a>.\u200b<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2-navigate-to-your-hosting-plan\">Step 2. Go to Control Panel<\/h2>\n\n\n\n<p>Once logged in:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Locate your hosting plan in the WPX client area.<\/li>\n\n\n\n<li>Click the <strong>Control Panel<\/strong> button next to the plan you wish to manage.<\/li>\n<\/ol>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0473f15f207&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0473f15f207\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1919\" height=\"796\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10.png\" alt=\"\" class=\"wp-image-12899\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10.png 1919w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-300x124.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-1024x425.png 1024w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-768x319.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-50x21.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-1536x637.png 1536w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-60x25.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-100x41.png 100w\" sizes=\"auto, (max-width: 1919px) 100vw, 1919px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">If you have more than five hosting plans of the same type (WordPress, Agency or WooCommerce), not all may appear on the homepage. Use the <strong>WordPress Hosting<\/strong>, <strong>Agency Hosting<\/strong> or <strong>WooCommerce Hosting<\/strong> tab in the left-hand menu to find your service.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 4. Export the database<\/h2>\n\n\n\n<p>Once inside <strong>phpMyAdmin<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select the database you want to export from the left-hand sidebar.<\/li>\n\n\n\n<li>Click on the <strong>Export<\/strong> tab at the top.<\/li>\n<\/ol>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0473f160034&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0473f160034\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"609\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-2-1.png\" alt=\"\" class=\"wp-image-13384\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-2-1.png 1080w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-2-1-300x169.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-2-1-1024x577.png 1024w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-2-1-768x433.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-2-1-50x28.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-2-1-60x34.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-2-1-100x56.png 100w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p>On the next screen, leave the default settings (Format: SQL) and click <strong>Go<\/strong>. Your database will begin downloading to your local machine as a <code>.sql<\/code> file.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0473f160424&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0473f160424\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"835\" height=\"471\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-3-1.png\" alt=\"\" class=\"wp-image-13383\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-3-1.png 835w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-3-1-300x169.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-3-1-768x433.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-3-1-50x28.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-3-1-60x34.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/05\/export-a-database-3-1-100x56.png 100w\" sizes=\"auto, (max-width: 835px) 100vw, 835px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon\">That&#8217;s it. You&#8217;ve successfully exported your database.<\/p>\n\n\n\n<p>Stuck at any point? Don\u2019t worry, just click the live chat widget in the bottom-right, and one of our support agents will assist you in <strong>under 30 seconds<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, you&#8217;ll learn how to export a database using phpMyAdmin in your WPX hosting account. Step 4. Export the database Once inside phpMyAdmin: On the next screen, leave the default settings (Format: SQL) and click Go. Your database will begin downloading to your local machine as a .sql&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":2,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","inline_featured_image":false,"footnotes":""},"ht-kb-category":[106],"ht-kb-tag":[],"class_list":["post-6708","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databases"],"_links":{"self":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/6708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/comments?post=6708"}],"version-history":[{"count":10,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/6708\/revisions"}],"predecessor-version":[{"id":13745,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/6708\/revisions\/13745"}],"wp:attachment":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/media?parent=6708"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=6708"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=6708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}