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:

Backing up a 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.
    phpMyAdmin_export_method
  4. On the next page you must select a 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. From the dropdown menu, choose the format you'd like to save the file as. SQL is most common.
  6. Click the Go button to continue.
  7. A pop-up displays allowing you to download the file. (Note: your browser may also download it automatically.)

Exporting a table

  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.
    phpMyAdmin_export_method
  5. On the next page you must select a 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. From the dropdown menu, choose the format you'd like to save the file as. SQL is most common.
  7. Click the Go button to continue.
  8. A pop-up display allowing you to download the file. (Note: your browser may also download it automatically.)

See also

Did this article answer your questions?

Article last updated .