Export MySQL Database Using phpMyAdmin

There are many situations where you may need to export a database, such as creating a backup, cloning the database to another website, or migrating it between servers. Here we cover the steps to export a MySQL database using phpMyAdmin.

Related Articles

Getting Started with cPanel
Export Database Using mysqldump

Export Database

1. Log into cPanel
2. Navigate to phpMyAdmin, located under the Databases Section
   
3. Select the database you wish to export
   
   

   TIP: If you are unsure of the correct database name, it can generally be found in the website's configuration file. Common configuration file locations:
   

   CMS	Filename
   WordPress	wp-config.php
   Magento 1.x	app/etc/local.xml
   Magento 2.x	app/etc/env.php
   PrestaShop < 1.7	config/settings.inc.php
   PrestaShop >= 1.7	app/config/parameters.php
   Joomla	configuration.php
   Drupal	sites/default/settings.php

4. Choose Export in the top menu
5. Choose the Export method and Format
   
   TIP: Most users should leave these on the default selections of Quick and SQL. 
6. Click the Go button
   
7. If prompted by your browser to open or save the file, choose Save and select the desired location on your computer or device to save the file