{"id":1186,"date":"2020-10-12T12:40:03","date_gmt":"2020-10-12T12:40:03","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2020\/10\/12\/4529011-how-to-export-a-database-with-phpmyadmin-in-hostinger\/"},"modified":"2026-05-20T08:22:06","modified_gmt":"2026-05-20T08:22:06","slug":"4529011-how-to-export-a-database-with-phpmyadmin-in-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/4529011-how-to-export-a-database-with-phpmyadmin-in-hostinger\/","title":{"rendered":"How to export a database with phpMyAdmin in Hostinger"},"content":{"rendered":"<p>You can easily export a database from your custom PHP or HTML websites hosted on Hostinger web, cloud, or agency hosting plans. This process is useful when you need to back up your data locally or move your website.<\/p><h2 id=\"h-before-you-start\">Before you start<\/h2><p>This guide applies to databases associated with custom PHP or HTML websites on web, cloud, and agency hosting plans.<\/p><ul>\n<li>Hostinger Website Builder does not support databases.<\/li>\n<li>Hostinger Horizons does not use phpMyAdmin; it utilizes an integrated backend instead.<\/li>\n<\/ul><h2 id=\"h-step-1-open-the-database-in-phpmyadmin\">Step 1 &ndash; Open the database in phpMyAdmin<\/h2><ol>\n<li>Go to hPanel <a class=\"intercom-content-link\" href=\"https:\/\/hpanel.hostinger.com\/websites\" target=\"_blank\" rel=\"noopener\">Websites<\/a> and click on <strong>Dashboard<\/strong> next to the website.<\/li>\n<li>On the side menu, select Databases &rarr; <strong>Management<\/strong>.<\/li>\n<li>Click on <strong>Enter phpMyAdmin<\/strong>.<\/li>\n<\/ol><p>For additional methods to reach phpMyAdmin, refer to this guide: <a href=\"https:\/\/www.hostinger.com\/support\/1583545-how-can-i-access-phpmyadmin\">How to access phpMyAdmin<\/a>.<\/p><h2 id=\"h-step-2-initiate-the-export\">Step 2 &ndash; Initiate the export<\/h2><ol>\n<li>Click the <strong>Export<\/strong> button on the phpMyAdmin top bar.\n<p class=\"no-margin\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-4639\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/475d4f54-4bad-40ac-83ec-48644b452f02.jpg\" alt=\"phpMyAdmin database export tab highlighted in the top menu\" width=\"778\" height=\"139\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/475d4f54-4bad-40ac-83ec-48644b452f02.jpg 778w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/475d4f54-4bad-40ac-83ec-48644b452f02-300x54.jpg 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/475d4f54-4bad-40ac-83ec-48644b452f02-768x137.jpg 768w\" sizes=\"(max-width: 778px) 100vw, 778px\" \/><\/p>\n<p>&nbsp;<\/p><\/li>\n<li>To export your database in SQL file format, which is the standard format for moving databases, scroll down and click <strong>Go<\/strong>. &#8203;<br>\n<img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/ae9de696-a3d2-442c-bffa-b368a37ad1dd.jpg\" alt=\"phpMyAdmin export page with the Go button highlighted for exporting a database\" width=\"500\" data-media-id=\"4640\"><\/li>\n<li>&nbsp;\n<div class=\"intercom-container intercom-align-center\">If you have specific requirements, such as a different file format or exporting only selected tables, select the <strong>Custom export<\/strong> method, adjust the settings, and click <strong>Go<\/strong>.<br>\n<img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/642c5954-de37-49bf-aff7-cba1d5f75faf.jpg\" alt=\"phpMyAdmin export page with Custom export selected and tables section highlighted\" data-media-id=\"4642\"><\/div>\n<\/li>\n<li>A copy of your database will download to your local device automatically.<\/li>\n<\/ol><p><strong>NOTE<\/strong><\/p><ul>\n<li>If you encounter issues using phpMyAdmin, you can try exporting your database <a href=\"https:\/\/www.hostinger.com\/support\/4536328-how-do-i-export-a-database-over-ssh\">via SSH<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Export your website database using phpMyAdmin on your Hostinger hosting plan<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[243],"tags":[],"class_list":["post-1186","post","type-post","status-publish","format-standard","hentry","category-importing-and-exporting-databases"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4529011-how-to-export-a-database-with-phpmyadmin-in-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4529011-como-exportar-una-base-de-datos-con-phpmyadmin-en-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4529011-bagaimana-cara-mengekspor-database-phpmyadmin-di-hostinger\/","default":0},{"locale":"lt-LT","link":"https:\/\/www.hostinger.com\/lt\/support\/4529011-kaip-eksportuoti-duomenu-baze-per-phpmyadmin-hostinger-platformoje\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4529011-como-exportar-um-banco-de-dados-pelo-phpmyadmin-no-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1186"}],"version-history":[{"count":3,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1186\/revisions"}],"predecessor-version":[{"id":10805,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1186\/revisions\/10805"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}