+- Sick Gaming (https://www.sickgaming.net)
+-- Forum: Programming (https://www.sickgaming.net/forum-76.html)
+--- Forum: PHP Development (https://www.sickgaming.net/forum-82.html)
+--- Thread: [Tut] phpMyAdmin – How to Export a Database? (/thread-100599.html)
[Tut] phpMyAdmin – How to Export a Database? - xSicKxBot - 01-17-2023
phpMyAdmin – How to Export a Database?
<div style="margin: 5px 5% 10px 5%;"><img src="https://www.sickgaming.net/blog/wp-content/uploads/2023/01/phpmyadmin-how-to-export-a-database.jpg" width="550" height="289" title="" alt="" /></div><div><div id="tutorial" readability="27.043832599119">
<div class="modified-on" readability="7.1304347826087"> by <a href="https://phppot.com/about/">Vincy</a>. Last modified on January 16th, 2023.</div>
<p>Do you want to take a backup of your database? Are you a beginner at using the phpMyAdmin application?</p>
<p>This article will guide you with straightforward bullet points to achieve this.</p>
<p>The phpMyAdmin provides an “Export” operation to take a backup with a few clicks.</p>
<h2>How to export databases and tables using phpMyAdmin?</h2>
<ol>
<li>Log in to the phpMyAdmin interface.</li>
<li>Choose the database from the left-side menu.</li>
<li>Click the “Export” tab that exists below the phpMyAdmin header.</li>
<li>Choose “Export Method” and “Format” of the exported to be in.</li>
<li>Click “Go” to see or download the exported data.</li>
</ol>
<p><strong>Note:</strong></p>
<p><img 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="(max-width: 550px) 100vw, 550px"></p>
<h2>Export methods allowed by phpMyAdmin</h2>
<p>There are two export methods allowed by the phpMyAdmin interface.</p>
<ol>
<li>Quick – Minimal and quick option to export the database and it is the default option.</li>
<li>Custom – This method allows more customization.</li>
</ol>
<p>The “Quick” method exports the selected database or table structure and data entirely.</p>
<p>But, the “Custom” method provides more options. Some of them are listed below.</p>
<ul>
<li>It allows selecting one are more tables from the list.</li>
<li>It allows exporting of either structure or data or both.</li>
<li>It provides the “Save-as” option to mention how to output the exported data. The phpMyAdmin can deliver the exported output in the below ways.
<ul>
<li>It will save it as a file if the user selects “Save output to a file”.</li>
<li>It will show as text on the interface if the user selects “View output as text”.</li>
</ul>
</li>
</ul>
<h2>Export formats provided by phpMyAdmin</h2>
<p>It supports numerous formats in which the output exported data. Some of them are listed below.</p>
<ul>
<li>SQL (default option)</li>
<li>CSV</li>
<li>JSON</li>
<li>XML</li>
</ul>
<h2>Export a database to another database</h2>
<p>To export a database to another database, we have to perform the phpMyAdmin “Import” after the “Export” action.</p>
<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>
<p> <!-- #comments --> </p>
<div class="related-articles">
<h2>Popular Articles</h2>
</p></div>
<p> <a href="https://phppot.com/mysql/phpmyadmin-export-database/#top" class="top">↑ Back to Top</a> </p>
</p></div>
<div id="social-icon">
<p>Share this page</p>
</p></div>
</div>
https://www.sickgaming.net/blog/2023/01/16/phpmyadmin-how-to-export-a-database/