{"id":131244,"date":"2023-01-16T12:17:02","date_gmt":"2023-01-16T12:17:02","guid":{"rendered":"https:\/\/phppot.com\/?p=20200"},"modified":"2023-01-16T12:17:02","modified_gmt":"2023-01-16T12:17:02","slug":"phpmyadmin-how-to-export-a-database","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2023\/01\/16\/phpmyadmin-how-to-export-a-database\/","title":{"rendered":"phpMyAdmin \u2013 How to Export a Database?"},"content":{"rendered":"<div id=\"tutorial\" readability=\"27.043832599119\">\n<div class=\"modified-on\" readability=\"7.1304347826087\"> by <a href=\"https:\/\/phppot.com\/about\/\">Vincy<\/a>. Last modified on January 16th, 2023.<\/div>\n<p>Do you want to take a backup of your database? Are you a beginner at using the phpMyAdmin application?<\/p>\n<p>This article will guide you with straightforward bullet points to achieve this.<\/p>\n<p>The phpMyAdmin provides an \u201cExport\u201d operation to take a backup with a few clicks.<\/p>\n<h2>How to export databases and tables using phpMyAdmin?<\/h2>\n<ol>\n<li>Log in to the phpMyAdmin interface.<\/li>\n<li>Choose the database from the left-side menu.<\/li>\n<li>Click the \u201cExport\u201d tab that exists below the phpMyAdmin header.<\/li>\n<li>Choose \u201cExport Method\u201d and \u201cFormat\u201d of the exported to be in.<\/li>\n<li>Click \u201cGo\u201d to see or download the exported data.<\/li>\n<\/ol>\n<p><strong>Note:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-large wp-image-20210\" src=\"https:\/\/phppot.com\/wp-content\/uploads\/2023\/01\/phpmyadmin-export-database-550x289.jpg\" alt=\"phpmyadmin export database\" width=\"550\" height=\"289\" srcset=\"https:\/\/phppot.com\/wp-content\/uploads\/2023\/01\/phpmyadmin-export-database-550x289.jpg 550w, https:\/\/phppot.com\/wp-content\/uploads\/2023\/01\/phpmyadmin-export-database-300x158.jpg 300w, https:\/\/phppot.com\/wp-content\/uploads\/2023\/01\/phpmyadmin-export-database-768x403.jpg 768w, https:\/\/phppot.com\/wp-content\/uploads\/2023\/01\/phpmyadmin-export-database.jpg 1200w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\"><\/p>\n<h2>Export methods allowed by phpMyAdmin<\/h2>\n<p>There are two export methods allowed by the phpMyAdmin interface.<\/p>\n<ol>\n<li>Quick \u2013 Minimal and quick option to export the database and it is the default option.<\/li>\n<li>Custom \u2013 This method allows more customization.<\/li>\n<\/ol>\n<p>The \u201cQuick\u201d method exports the selected database or table structure and data entirely.<\/p>\n<p>But, the \u201cCustom\u201d method provides more options. Some of them are listed below.<\/p>\n<ul>\n<li>It allows selecting one are more tables from the list.<\/li>\n<li>It allows exporting of either structure or data or both.<\/li>\n<li>It provides the \u201cSave-as\u201d option to mention how to output the exported data. The phpMyAdmin can deliver the exported output in the below ways.\n<ul>\n<li>It will save it as a file if the user selects \u201cSave output to a file\u201d.<\/li>\n<li>It will show as text on the interface if the user selects \u201cView output as text\u201d.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Export formats provided by phpMyAdmin<\/h2>\n<p>It supports numerous formats in which the output exported data. Some of them are listed below.<\/p>\n<ul>\n<li>SQL (default option)<\/li>\n<li>CSV<\/li>\n<li>JSON<\/li>\n<li>XML<\/li>\n<\/ul>\n<h2>Export a database to another database<\/h2>\n<p>To export a database to another database, we have to perform the phpMyAdmin \u201cImport\u201d after the \u201cExport\u201d action.<\/p>\n<p>In a previous tutorial, we have seen <a href=\"https:\/\/phppot.com\/mysql\/phpmyadmin-import-database\/\">how to import a database using phpMyAdmin<\/a>.<\/p>\n<p> <!-- #comments --> <\/p>\n<div class=\"related-articles\">\n<h2>Popular Articles<\/h2>\n<\/p><\/div>\n<p> <a href=\"https:\/\/phppot.com\/mysql\/phpmyadmin-export-database\/#top\" class=\"top\">\u2191 Back to Top<\/a> <\/p>\n<\/p><\/div>\n<div id=\"social-icon\">\n<p>Share this page<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>by Vincy. Last modified on January 16th, 2023. Do you want to take a backup of your database? Are you a beginner at using the phpMyAdmin application? This article will guide you with straightforward bullet points to achieve this. The phpMyAdmin provides an \u201cExport\u201d operation to take a backup with a few clicks. How to [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":131245,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-131244","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php-updates"],"_links":{"self":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/131244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/comments?post=131244"}],"version-history":[{"count":0,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/131244\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media\/131245"}],"wp:attachment":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media?parent=131244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/categories?post=131244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/tags?post=131244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}