{"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":"2025-08-27T07:09:49","modified_gmt":"2025-08-27T07:09:49","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 class=\"no-margin\">You can easily export a database from your Hostinger Web or Cloud hosting plan by following these steps:<\/p><ol>\n<li>\n<p class=\"no-margin\">Open the database using <b><a href=\"\/support\/1583545-how-can-i-access-phpmyadmin\" target=\"_blank\" class=\"intercom-content-link\">phpMyAdmin<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Click the <b>Export <\/b>button on the phpMyAdmin top bar:<\/p>\n<p>&#8203;<\/p>\n<div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/475d4f54-4bad-40ac-83ec-48644b452f02.jpg\" alt=\"The phpMyAdmin main page showing how to initiate database exporting\"><\/div>\n<p class=\"no-margin\">\n<\/p><\/li>\n<li>\n<p class=\"no-margin\">To export your database in SQL file format, which is the most commonly used when moving databases, scroll down and click on <b>Go<\/b>:<\/p>\n<p>&#8203;<\/p>\n<div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/ae9de696-a3d2-442c-bffa-b368a37ad1dd.jpg\" alt=\"The Exporting tables section showing the quick export method selected and how to start the process\" width=\"500\"><\/div>\n<p class=\"no-margin\">\n<\/p><\/li>\n<li>\n<p class=\"no-margin\">If you have special requirements , such as a <b>different file format<\/b> or export <b>only some tables<\/b> from your database, select the <b>Custom<\/b> export method and adjust the settings accordingly:<br>&#8203;<\/p>\n<\/li>\n<\/ol><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/642c5954-de37-49bf-aff7-cba1d5f75faf.jpg\" alt=\"The custom database export method showing the customization options\"><\/div><p class=\"no-margin\">That&rsquo;s it! Once you click <b>Go<\/b>, a copy of your database will be downloaded to your local device. <\/p><div class=\"intercom-interblocks-callout\" style=\"background-color: #e3e7fa80;border-color: #334bfa33\">\n<p class=\"no-margin\">If you encounter any issues using this method, try <b><a href=\"\/support\/4536328-how-do-i-export-a-database-over-ssh\" target=\"_blank\" class=\"intercom-content-link\">exporting via SSH<\/a><\/b> &#128161; <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Exporting a database via phpMyAdmin at Hostinger<\/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":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1186\/revisions"}],"predecessor-version":[{"id":4644,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1186\/revisions\/4644"}],"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}]}}