---
title: How to export a database using phpMyAdmin
description: How to export a cPanel database using phpMyAdmin, whether for a backup or to import it somewhere else.
---

[Skip to content](https://help.blakemarkdigital.co.uk/how-to-export-a-database-using-phpmyadmin#main-content)

English - United Kingdom

Show submenu for translations

[More support](https://help.blakemarkdigital.co.uk/kb-tickets/new) [Support Portal](https://help.blakemarkdigital.co.uk/support-portal)

[![Blake Mark Digital Logo](https://help.blakemarkdigital.co.uk/hs-fs/hubfs/Asset%205.png?width=200&height=57&name=Asset%205.png)](https://blakemarkproductions.com/)

Open main navigation

Close main navigation

- English - United Kingdom
  
  Show submenu for translations
- [More support](https://help.blakemarkdigital.co.uk/kb-tickets/new)
- [Support Portal](https://help.blakemarkdigital.co.uk/support-portal)
- [Contact Support](https://help.blakemarkproductions.com/support-portal)

[Contact Support](https://help.blakemarkproductions.com/support-portal)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.blakemarkdigital.co.uk/)
2. [cPanel](https://help.blakemarkdigital.co.uk/cpanel)

# How to export a database using phpMyAdmin

This guide explains how to export a cPanel database using phpMyAdmin. This can be useful should you just need to take a backup, or wish to export your database for you to later import elsewhere.

This guide assumes you're [logged in to the cPanel account](https://help.blakemarkdigital.co.uk/how-do-i-login-to-my-hostings-cpanel-control-panel) containing the database to export.

1. Open **phpMyAdmin** by clicking the icon in the **Databases** section.
   
   ![](https://files.helpdocs.io/8nzbvyta9f/articles/5inxp2k6ym/1651054449696/export-db-php-my-admin-image-1.png)
2. Click the name of the database you'd like to export in the left-hand column.  
   You'll see the tables listed below the database name and expanded into the main pane. You'll also see the selected database name detailed at the top of the window.
   
   ![](https://files.helpdocs.io/8nzbvyta9f/articles/xm1o8t54x1/1582023037368/screenshot-489.jpg)
3. Click the **Export** tab.
   
   ![](https://files.helpdocs.io/8nzbvyta9f/articles/xm1o8t54x1/1582023170859/screenshot-490.jpg)
   
    The Export method is set to **Quick** by default and the Format set to **SQL**.  
   Click **Go** to start the export - depending on your browser you may be prompted to Save or Open the download - we'd suggest clicking **Save** and the export will be saved to your Downloads location.  
   The default options will usually be fine - but should you wish to explore the Custom options to include things like the CREATE database command in the export or change the export Format you can do so here.  
   For full details of the other export Formats we've included a link to the phpMyAdmin documentation: [phpMyAdmin Import & Export documentation](https://docs.phpmyadmin.net/en/latest/import_export.html#export).

- [Getting Started](https://help.blakemarkdigital.co.uk/getting-started)
- [Web Hosting](https://help.blakemarkdigital.co.uk/web-hosting#main-content)

    - [Elementor](https://help.blakemarkdigital.co.uk/web-hosting#elementor)
    - [WordPress](https://help.blakemarkdigital.co.uk/web-hosting#wordpress)
    - [Security](https://help.blakemarkdigital.co.uk/web-hosting#security)
- [Email](https://help.blakemarkdigital.co.uk/email#main-content)

    - [Mail Clients](https://help.blakemarkdigital.co.uk/email#mail-clients)
    - [SpamExperts](https://help.blakemarkdigital.co.uk/email#spamexperts)
    - [MailChannels](https://help.blakemarkdigital.co.uk/email#mailchannels)
- [Domains](https://help.blakemarkdigital.co.uk/domains#main-content)

    - [Domain Privacy](https://help.blakemarkdigital.co.uk/domains#domain-privacy)
- [Billing](https://help.blakemarkdigital.co.uk/billing)
- [cPanel](https://help.blakemarkdigital.co.uk/cpanel#main-content)

    - [JetBackup](https://help.blakemarkdigital.co.uk/cpanel#jetbackup)
    - [Softaculous](https://help.blakemarkdigital.co.uk/cpanel#softaculous)
- [WordPress Glossary Terms](https://help.blakemarkdigital.co.uk/wordpress-glossary-terms#main-content)

    - [H](https://help.blakemarkdigital.co.uk/wordpress-glossary-terms#h)

[![Blake Mark Digital Logo](https://help.blakemarkdigital.co.uk/hs-fs/hubfs/Asset%205.png?width=250&height=71&name=Asset%205.png "Blake Mark Digital Logo")](https://blakemarkdigital.co.uk/)

Blake Mark Digital is a digital marketing agency supporting SMEs and non-profits with strategic branding, content, and campaigns that drive real results

124-128 City Road, London, EC1V 2NX

[support@blakemarkdigital.co.uk](mailto:support@blakemarkdigital.co.uk)

+44 20 4578 9582

<https://www.facebook.com/blakemarkproductions> <https://www.instagram.com/blakemarkproductions/> <https://blakemarkproductions.com/podcast> [mailto:support@blakemarkproductions.com](mailto:support@blakemarkproductions.com)

Copyright © Blake Mark Productions Ltd