Exporting a MySQL Database via phpMyAdmin

Instructions for exporting a database, also know as a database dump.

In this article:

Video Tutorial

This video shows how to export data from your MySQL database using phpMyAdmin. A link to phpMyAdmin can be found in your HostGator control panel (cPanel or Plesk depending on your hosting package).

The directions in the video may differ slightly from the directions listed below.  Additional directions not found in the video on how to get to phpMyAdmin for cPanel and Plesk users are also listed below.

Finding phpMyAdmin in your 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.

Plesk

  1. Login to Plesk.
  2. Click on the Website & Domains tab at the top.
  3. Click on Databases in the list of functions.
  4. Click on the database you wish to access.
  5. Click on WebAdmin in the Tools section.
  6. phpMyAdmin will open to the screen for administrating the database you selected.

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.

More in-depth instructions, including explanations of different options on the export screen, can be found in the video.

Notes and Concepts

For the video tutorial, we are connected to phpMyAdmin using the "root" MySQL user.  When connecting as another user, some options may be disabled, depending on the server's configuration and the specific privileges granted to the user by the system administrator.

On systems with Plesk, the master MySQL user is the "admin" user instead of "root."

Many systems, like HostGator's servers, are configured with control panel software installed used to delegate the administration of the account on the server.  Whenever possible, it is recommended you use the controls within the control panel itself for certain tasks (such as creation of databases, creation of users, management of user privileges, etc.) instead of phpMyAdmin.  Performing these tasks outside the control panel can produce undesired results in the operation of the control panel software.

On Linux based systems, database names, database users, table names and column names are case sensitive, whereas on Windows based systems they are case insensitive.


cPanelcPanel is a popular web hosting control panel that helps you manage your hosting account and assists you in creating web sites, managing e-mail addresses, & installing applications to a server.

cPanel is available on all HostGator Linux hosting plans, including Shared Hosting, Reseller Hosting, VPS and Linux Dedicated Servers.