phpMyAdmin — How to backup or export a database or table

The following steps are also available as an instructional video:

To export (back up) your entire database:

1. Log into phpMyAdmin.
2. Select the source database on the left pane.
3. Click the Export tab in the top center pane.
4. Select the Quick or Custom export method.

   The Quick method allows you to download the .sql file immediately.

   The Custom method gives you more control over the data. Only use the Custom method if you're very familiar with managing SQL tables.

5. Choose the format you'd like to save the file as from the dropdown menu. SQL is most common.
6. Click the Go button to continue.

A pop-up displays allowing you to download the file. (Note: your browser may also download it automatically.)

To export (or back up) a single table within your database:

1. Log into phpMyAdmin.
2. Select the source database on the left pane.
3. Select the table you wish to export on the left pane under the database name.
4. Click the Export tab in the top center pane.
5. Select Quick or Custom export method.

   The Quick method allows you to download the .sql file immediately. 

   The Custom method gives you more control over the data. Only use the Custom method if you're very familiar with managing SQL tables.

6. Choose the format you'd like to save the file as from the dropdown menu. SQL is the most common.
7. Click the Go button to continue. 

A pop-up displays allowing you to download the file. (Note: your browser may also download it automatically.)