Login

phpMyAdmin – How to Export a Database?

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

How to export databases and tables using phpMyAdmin?

Note:

phpmyadmin export database

There are two export methods allowed by the phpMyAdmin interface.

Quick – Minimal and quick option to export the database and it is the default option.
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”.

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

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