phpMyAdmin — How to backup or export a database or table

Overview

These instructions explain how to backup your entire database, or export any given table separately.

Backing up a Database

Log into phpMyAdmin by connecting to your cPanel account and clicking the phpMyAdmin link:

Select the source database on the left pane.

  • If you want to export a specific table, select the table you want to export under the database name:

Click on the Export tab in the top center pane.

On the next page you must select a Quick or Custom export method.

From the dropdown menu, choose the format you’d like to save the file as. SQL is most common.

format01

Click the Go button to continue.

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

What about importing or restoring a database?

If you’re interested in importing a table or database, follow this guide.