How to Export a MySQL Database through phpMyAdmin Print

  • cPanel, phpMyAdmin, MySQL Database, Export
  • 315

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.

Login - to - cPanel

STEP 2: In the Databases section, click on phpMyAdmin.

cPanel - Databases Section - 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.

Select Database - Export

STEP 7: By default, the Quick Export method will be selected.

STEP 8: Scroll down and click Export.

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

cPanel - Files Section - File Manager

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.

Download a MySQL Database Backup section - Database to Backup

The system will generate and download the backup file to your device.


Was this answer helpful?

« Back