phpMyAdmin – How to Export a Database?

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 “Export” operation to take a backup with a few clicks.

How to export databases and tables using phpMyAdmin?

1. Log in to the phpMyAdmin interface.
2. Choose the database from the left-side menu.
3. Click the “Export” tab that exists below the phpMyAdmin header.
4. Choose “Export Method” and “Format” of the exported to be in.
5. Click “Go” to see or download the exported data.

Note:

• These 5 points export data to a file and download it to the browser. If you need more customization on the export, continue reading.
• If you don’t have a database, create it in phpMyAdmin to experiment with the steps to export.

Export methods allowed by phpMyAdmin

There are two export methods allowed by the phpMyAdmin interface.

1. Quick – Minimal and quick option to export the database and it is the default option.
2. Custom – This method allows more customization.

The “Quick” method exports the selected database or table structure and data entirely.

But, the “Custom” method provides more options. Some of them are listed below.

• It allows selecting one are more tables from the list.
• It allows exporting of either structure or data or both.
• 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.
  • It will save it as a file if the user selects “Save output to a file”.
  • It will show as text on the interface if the user selects “View output as text”.

Export formats provided by phpMyAdmin

It supports numerous formats in which the output exported data. Some of them are listed below.

• SQL (default option)
• CSV
• JSON
• XML

Export a database to another database

To export a database to another database, we have to perform the phpMyAdmin “Import” after the “Export” action.

In a previous tutorial, we have seen how to import a database using phpMyAdmin.

Written by Vincy, a web developer with 15+ years of experience and a Masters degree in Computer Science. She specializes in building modern, lightweight websites using PHP, JavaScript, React, and related technologies. Phppot helps you in mastering web development through over a decade of publishing quality tutorials.

↑ Back to Top

• PHP
• jQuery
• JavaScript
• WordPress
• MySQL
  • MySQL Basics
  • phpMyAdmin
    • How to Install phpMyAdmin on a Windows?
    • phpMyAdmin - How to Create a Database?
    • phpMyAdmin - How to Import a Database?
    • phpMyAdmin - How to Export a Database?
    • phpMyAdmin - How to Connect a Remote Database?
• CSS

• Share
• Tweet
• Share

1. Simple PHP Shopping Cart
2. Stripe Payment Gateway Integration using PHP
3. User Registration in PHP with Login: Form with MySQL and Code Download
4. PHP Contact Form
5. How to Create Dynamic Stacked Bar, Doughnut and Pie charts in PHP with Chart.js