phpMyAdmin — How to backup or export a database or table

View the following article for details on how to find your login credentials and log into phpMyAdmin:

• Finding your phpMyAdmin login credentials

Once logged in, proceed with the steps below.

The following section is also available as an instructional video:

These instructions explain how to export (back up) your entire database.

1. Log into phpMyAdmin.

   

2. Select the source database on the left pane.

   

3. Click on the Export tab in the top center pane.

   

4. Select Quick or Custom export method.

   Choosing 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.)

The following section is also available as an instructional video:

These instructions explain how to export (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 on the Export tab in the top center pane.

   

5. Select Quick or Custom export method.

   Choosing 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 most common.
7. Click the Go button to continue.

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