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 the Quick or Custom export method. Then, from the dropdown menu, choose the format you’d like to save the file as. SQL is most common.
Click the Export 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.