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