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.

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Reclaim Hosting Support Hours
8:00 am - 5:00 pm ET, Monday through Friday
Submit a Ticket
Get a quick and helpful response from the pros.
Need Extra Support?
No problem, we're here to help! Talk to us about Professional Services.