How to Export a Database Using phpMyAdmin

There are two ways to export a database with phpMyAdmin depending on the version installed on your app.

Exporting from a Newer Version of phpMyAdmin

The latest version offers the simplest means.

First, after logging in to phpMyAdmin, select your database from the list on the left.

Next, click the Export tab.

Then, select Quick as the Export Method and SQL from the Format drop-down list. Click Go.
phpmyadmin

If you’re exporting from an older version of phpMyAdmin, follow these steps after clicking the Export tab.

In the Export box, click Select All and the radial button for SQL. Leave the Options box as is.

Place a check mark next to Save as file and click Go.
phpmyadmin

phpMyAdmin will export your database to the destination on your computer.

Alert: For Control Panel Help & Tutorials, click here: Panel Tutorials

Introduction If you are configuring backups of a server, you need to know what data to back up....

This is an advanced tutorial. It can sometimes be useful to enable remote connections to MySQL....

Introduction Normally, you access each MySQL database using a separate database user. In some...

If your app was written for older versions of MySQL and is not compatible with strict SQL mode in...

If you're not familiar with using SSH, it's easier to export a database using Adminer. However,...