Exporting a database, also referred to as creating a database dump, allows you to back up your data or move it to another server. Here’s how to do it:
How to Access phpMyAdmin in your cPanel:
Once your database is created, follow these steps to access it via phpMyAdmin:
STEP 1: Log in to cPanel.
There are two methods to log into your cPanel.
- Method 1: Log in to your cPanel directly.
- Method 2: Log in to your cPanel through your Customer Portal.
Through your Customer Portal;
- Log in to your Customer Portal.
- Click on the "Log in to cPanel" icon.
STEP 2: In the Databases section, click on phpMyAdmin.
STEP 3: Once on the phpMyAdmin homepage, locate the username panel on the top left-side.
STEP 4: Expand the username to view a list of all available databases associated with your account.
STEP 5: Select the database you wish to export from the list of available databases in phpMyAdmin.
STEP 6: Click the Export tab located on the top menu.
STEP 7: By default, the Quick Export method will be selected.
STEP 8: Scroll down and click Export.
This will download a .sql file into your computer. Depending on the database's size, the downloading may take some time..
Exporting a Database through cPanel's Backup Feature
As an alternative to phpMyAdmin, you can use cPanel’s Backup tool to export your database.
STEP 1: Log in to cPanel (Refer to the steps above if you need guidance on accessing your cPanel.)
STEP 2: Locate the Files section and click on Backup.
STEP 3: Scroll down the Backup page to find the Download a MySQL Database Backup section.
STEP 4: Locate and click on the name of the database you want to back up.
The system will generate and download the backup file to your device.