Create an account

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Tut] phpMyAdmin – How to Export a Database?

phpMyAdmin – How to Export a Database?

<div style="margin: 5px 5% 10px 5%;"><img src="" width="550" height="289" title="" alt="" /></div><div><div id="tutorial" readability="27.043832599119">
<div class="modified-on" readability="7.1304347826087"> by <a href="">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>
<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>
<p><img loading="lazy" class="alignnone size-large wp-image-20210" src="" alt="phpmyadmin export database" width="550" height="289" srcset=" 550w, 300w, 768w, 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>
<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>
<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>
<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.
<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>
<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>
<li>SQL (default option)</li>
<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="">how to import a database using phpMyAdmin</a>.</p>
<p> <!-- #comments --> </p>
<div class="related-articles">
<h2>Popular Articles</h2>
<p> <a href="" class="top">↑ Back to Top</a> </p>
<div id="social-icon">
<p>Share this page</p>

Forum Jump:

Users browsing this thread:
1 Guest(s)

Forum software by © MyBB Theme © iAndrew 2016