How to Export a MySQL Database via phpMyAdmin

Finding phpMyAdmin in Control Panel

One you have created a database, you can access it via the web administration panel.

cPanel

  1. Login to cPanel.
  2. There will be an icon for phpMyAdmin in the Databases section.  This will take you to phpMyAdmin. 
  3. The list of available databases will be listed on the left hand side once you get into phpMyAdmin.

Instructions on Exporting a Database

  1. Go to an existing database in phpMyAdmin.
  2. Click Export at the top.
  3. Leave the settings as they are, click the "Save as file" checkbox and click Go.
  4. This will download a .sql file to your computer.
Was this answer helpful? 59 Users Found This Useful (186 Votes)

Related Articles

How Do I Create and Delete a Cron Job?

Create a Cron Job To create a cron job: Log into cPanel. In the Advanced section, click Cron...

 PHP guide how to change max_execution_time value ?

In this article, you will find, how to change the max_execution_time for PHP scripts by using the...

 How to Change Language of your cPanel?

cPanel supports a lot of languages, and if you want to change your cPanel language to your native...

 How to Access phpMyAdmin from cPanel?

To access phpMyAdmin from cPanel, simply log in to cPanel and click the phpMyAdmin icon in the...

 How to create Cronjob via cPanel?

1. Log into your cPanel account.2. In the "Advanced" section, click on "Cron Jobs" Icon. 3. Under...